Dan Waters
dwaters at usinternet.com
Fri Sep 28 19:54:31 CDT 2007
Steve, SQL Server 2005 (Express) has a very nice separate application called SQL Server Management Studio (Express) for managing tables, view, sp's, etc. The Express version is a free download. To convert queries to view and sp's, can you use an upsizing wizard? MS has a new one called SQL Server Migration Assistant (SSMA) for Access. I think someone on this list has already used it. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach Sent: Friday, September 28, 2007 6:40 PM To: Access Developers discussion and problem solving Subject: [AccessD] SQL Server 2005 and Access 2003 interaction Dear Group, Is what I've heard correct: that the very nice Access-to-SQL Server connectivity ain't quite the same any more with SQL Server 2005? That is, coding stored procedures or creating tables from the Access interface, things like that? I'm hoping to be able to use Access 2003 to convert the queries contained in an Access application to views and sp's in SQL Server 2005. Am I going to be out of luck? Regards, Steve Erbach Neenah, WI -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com