OK, if you want to make the move, and you want it to be painless and seamless, then the best start is to use the upsizing wizard (you may need to rename the linked tables without the dbo prefix) then start using the SQL database with the ODBC links.
Everything should then work just as before and all your DAO code still works.
There is nothing to stop you using ODBC, as well as ADO, so now you can start creating the SQL server specific stuff, like stored procedures and views etc with ADO connections without losing any of your old functionality.
1 comment:
OK, if you want to make the move, and you want it to be painless and seamless, then the best start is to use the upsizing wizard (you may need to rename the linked tables without the dbo prefix) then start using the SQL database with the ODBC links.
Everything should then work just as before and all your DAO code still works.
There is nothing to stop you using ODBC, as well as ADO, so now you can start creating the SQL server specific stuff, like stored procedures and views etc with ADO connections without losing any of your old functionality.
Post a Comment