DAO code to ADODB

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
John said:
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?
Click to expand...

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
 
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
 
Back
Top