[AccessD] Update Access 2003 to deal with SQL 2005?

Arthur,

<<Is there any way around this? >>

  No.  Your only choice is to connect to SQL 2005 via ODBC rather then as an
ADP.  Microsoft has no plans to updated the ADP capability in Access 2003.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, June 29, 2007 1:03 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Update Access 2003 to deal with SQL 2005?

Hello all,

I'm building an app in Access 2003 that needs to talk to SQL 2005. Every
time I try to do something involving the back end, I get the message:

"You have connected to a version of SQL Server later than SQL Server 2000.
The version of Visual Studio or Access that you are using was released
before the version of SQL Server to which you are connected.  For this
reason, you might encounter problems.

Please check with Microsoft to see if there is a service pack that you
should apply to Visual Studio or Office in order to get support for the
version of SQL Server to which you are connected.

You can continue but any new object types might not be enumerated, and it
will not be possible to save any objects or database diagrams that you
create using the Visual Database Tools."

Is there any way around this? I don't really mind running both VS
Studio.NETand Access 2003 at the same time, but do you know of an
update that
rectifies this? I looked and didn't find one.

TIA,

Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com