Access front-end: DAO Coding w/ SQL 7.0

[BethC731]

I've inherited an Access database (.mdb) that contains tables that are linked to a SQL 7 database. DAO is used for all data access.

Due to hardware issues, I may need to quickly upgrade the back-end database from SQL 7 to SQL 2000. I am hoping that I will not need to make too many changes to my VB code. I know that an .adp coded with ADO is the best way to go, but that is not an option right now.

What have your experiences been upgrading from SQL 7 to SQL 2000? Did you have to make a lot of changes to your DAO code? Any advice would be greatly appreciated.

 

[SonOfEmidec1100]

From memory no changes required for accessing your user data.

As I recall there were a few field name changes in some system tables/SPs - bit vague now been a while.