I've written an application in Visual Basic 6, it uses DAO database calls to grab data from an Access 97 backend. The data names are referenced via windows ODBC names.
As the database has significantly grown, I'd like to upgrade the backend to Sql Server Express edition.
Des SQL Server Express 2005 edition support DAO methods? Has anyone ever done a migration like this? Any other tips or suggestions? Thanks.
Just to give an overview of the connection...
-user loads client EXE (VB)
-client creates reference using ODBC name to data recordsets.
-client updates or views data from database using DAO methods.
The client has a builtin reference to MS DAO 2.5/3.5 compatibility library.