Access 2007 compatibility with SQL Server 2008

[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,

 

[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?

 

[AccessVandal via AccessMonster.com]

See here:
http://blogs.msdn.com/access/
-----------------------------------------------------
ADP’s and SQL Server 2008
We have been getting a bunch of email from customers about using ADP’s with
SQL Server 2008 and wanted to give everyone and update and some guidance.

Access 2007 ADP’s will run against SQL Server 2008 but do not support
designing server objects (tables, views, stored procedures, functions and
relationships).

SQL Server 2008 shipped after Office 2007 SP1 and after we had locked down
all the fixes for Office 2007 SP2 (coming out in a few months).

If you rely on the design features of ADP’s we recommend;

Stick with SQL 2005
If you do make the move to 2008 use the SQL Server Management Studio to
design your server objects.
------------------------------------------------------------

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?

Hello,
Though I found similar questions, I didn't find the answer so I'm

[quoted text clipped - 18 lines]

Thanks beforehand,