DAO code to ADODB

[John]

Hi

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

 

[Tony Toews [MVP]]

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?

No.

But it is suggested you upgrade to a newer version of Access as it
will solve some issues with SQL Server. I don't recall which right
now though.

Tony

 

[Mary Chipman [MSFT]]

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.aspf...ifferences-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