Access 2007 compatibility with SQL Server 2008

J

Jacques Latoison

Hello,
Though I found similar questions, I didn't find the answer so I'm
posting the below problem.

I cannot get Access 2007 to connect and create a DB through the ADP wizard
on SQL 2008.

Oddly enough, I have a SQL 2005 installation elsewhere, with two different
instances on the same box.

All SQL Servers are Windows 2008 Enterprise x64.

The SQL 2005 had an instance that was upgraded from SP2 to 3 and it still
takes connections.
The SQL 2005 second instance DOES not accept connection from Access (or
other packages).
The SQL 2008 installation (on a seperate server) also will not accept
connections from Access 2007.

Any ideas would be appreciated.

Thanks beforehand,
 
J

Jacques Latoison

I got a message from Access 2007 that the version of SQL is newer than
Office, and I should go to Microsoft for a service pack or update for Office
(and Visual Studio) to talk to this version of SQL.

Does anyone know of such a patch or service pack?
 

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

Using Access 2007 adp project files with SQL Server 2008 Express 3
Access 2003 or 2007 Compatible with SQL Server 2008 6
ADP with 64 Bit SQL 2008 4
Exporting tables from SQL 2008 DB 3
Access 2007 ADP project will not connect to SQL Server 2008 2
Access 2007 can't connect to SQL Server 1
DSN for SQL Server 2008 from Access 4
SQL Server 2005 schema for Access 2007 ADP 2

Top