Help connecting to SQL Server 2005

G

Guest

I am trying to create a new project in Access 2003 that will allow me to
create procedures, etc. in a SQL Server database that Access creates. It
says that my version of Access won't save design structures because of the
version of SQL Server I am trying to link to. What is the download I need to
seemlessly link to sql server 2005 x64 bit version?

Jeff
 
S

Sylvain Lafontaine

The current version of Access 2003 cannot connect to SQL-Server 2005 for
design change (or creation) - it can connect only for accessing data - and
there is no available (hot)fixe for this to my knowledge.

You will have to use other tools than Access 2003 for designing your
database on SQL-Server 2005.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link to SQL Server 2005 2
Cannot link to SQL server 17
CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008 1
Upsize to sql server overrides sql server default location--why? 3
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
docmd.transferdatabase access 2003 to sql 2005 2
How to Upgrade SQL back end of Access linked tables. 7
Move Access Table to SQL Server 1

Top