As Tony recommended, getting the most recent version of Access will be
essential to succeeding with your upsizing project. In addition, here
are some other resources which you may find useful:
TechEd Online Panel (video):
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for: "Are we there yet? Successfully navigating the bumpy road
from Access
to SQL Server"
Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx or
download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/SQLAccessWhatsRight.doc
Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx
What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html
"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446
--Mary
Post by JohnHi
I have an Access 97 front-end/backend db app. I am required to upgrade the
backend to sql server in near future.
1. Is it a good idea to convert my DAO code to ADODB before upsizing to SQL
Server?
2. If so, what is the method to convert DAO code to ADODB?
Many Thanks
Regards