Answer for:

Using MS Access and ODBC to access an SQL Database

Message 6 of 13

View entire thread
0 Votes

I am assuming that when you previously connected to dBase III, you were using DAO, which will not work with object oriented SQL databases. When connecting to SQL databases, like SQL Express, MS SQL server, or MySQL, you need to use ADO.