Dan Waters
dwaters at usinternet.com
Fri Jun 29 15:36:48 CDT 2007
Arthur, The SQL 2005 Management Studio (Full or Express) may be a good way to manage a SQL 2005 database. I think it can take the place of the visual management tools used by Access for the full version of SQL 2000. MS never did have a similar tool for MSDE 2000. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, June 29, 2007 12:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com