Access 2000 & SQL Server 2005

  • Thread starter Thread starter pjakop1
  • Start date Start date
P

pjakop1

I am trying to first use an access .adp project of acces 2000 with sql
server 2005. I can create project, I can also connect it with existing
database using "sa" login, but when I try to add table I get the
folowing error:
"You do not have exclusive access to the database at this time. Your
design changes will not be saved."

If I try to create new database on server, after the message that
access have enough information to create database, i get the folowing
error:

"An error occured whle trying to create the database; the wizard can't
continue. (Server Error 1803: CREATE DATABASE failed. Primary file
must be et least 3MB to accomodate a copy of the model database.) Your
ADP file will not be connected to a server database."

any ideas?
 
You cannot use Access ADP 2000, 2002 or 2003 to design a table against
SQL-2005; for that, you must use Access 2007. Access 2000/2/3 work properly
only against SQL-2000.
 
I always use the sql server tools to create tables in sql server. It is
easier than doing it from access, but you must have the sql server client
toools on your pc.

Tore
 
T. Gylver said:
I always use the sql server tools to create tables in sql server. It is
easier than doing it from access,
Click to expand...

Not necessarily. Prior to SQL Server2005, with Access200x ADP, it is very
convenient to do table/view design (IMO, better than you can do in
Enterprise Manager). As developer, I found myself very often in th eneed to
duplicate/copy table/view/SPs/UDF between SQL Server databases. With ADP,
you can simply copy and paste, while with Enterprise Manager, thing aren't
as easy, not even close. Even with SQL Server Management Studio, you still
can't. When MSDE1.0 came out, you can even use ADP to manage SQL Server
security (it was gone since MSDE2000 and Access2002, too bad)!

So, I still use ADP as SQL Server database management tool for development
purpose in routine work, mostly creating/modifying table/views/SP... Only go
to EM or SSMS for something I cannot do with ADP. Did I mention that SSMS is
so slow to run?
 
Back
Top