My random thoughts on SQL Server Upsizing from Microsoft Access

[ SQL Server Upsizing | Access Tips | Main ] (Updated 2010/09/27) 

Informational Links

• How to read Access database data from 64-bit SQL Server 2005.
• MSDE—The missing piece
• Relink ODBC tables from code
• Using DSN-Less Connections
• HOWTO: Create and Remove a DSN in Visual Basic - 171146
• HOWTO: Programmatically Create a DSN for SQL Server with VB - 184608
• ACC: Procedure to Create Data Sources and Relink ODBC Tables - 159691
• Sample ADO connection strings by Carl Prothman, fellow MVP
• Microsoft Access 2000 and SQL Integration Resources
• VBUG Magazine - From Access to SQL Server (A bit out of date as it discusses A97 and SQL Server 7.0)
• ASPFAQ.COM - What do I need to know about the differences between Access and SQL Server?
• Microsoft Access and Upsizing from Ms Access 2000 to SQL Server 7.0
• ZDNet: Upsizing an existing Microsoft Access database (2003-09-04)
• Upsize ASP From Access to SQL Server (pdf file) (2003-09-04)
• MSDN > Office > Optimizing Client/Server Performance (2003-09-17) 
• DataFast Consulting Click on Downloads and look for "Catalog SQL Scripts", "DataFast Utility A97 & A2K", "DSN-Less ODBC" and more.  Search using "SQL"  (2003-11-29) 
• SQL-tool Create a SQL script for your tables.  Code Modules >> Code Section

Performance and SQL Server

• INF: Troubleshooting Application Performance with SQL Server - 224587
• INF: Troubleshooting Performance of Ad-Hoc Queries - 243588
• HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later - 243589

Random assortment of Knowledge Base Links

• ACC2002: Descending Indexes Become Ascending Indexes When Upsizing to SQL Even After Office XP SP-2 Is Installed - 328019

[ SQL Server Upsizing | Access Tips | Main ]

   Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks.

Granite Fleet Manager - the best designed fleet maintenance tracking and management system available