Discussion:
DAO code to ADODB
(too old to reply)
John
2009-05-03 03:24:09 UTC
Permalink
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]
2009-05-03 06:05:31 UTC
Permalink
Post by John
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
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
Mary Chipman [MSFT]
2009-05-07 16:01:27 UTC
Permalink
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 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
Loading...