theravada_maha
asked on
Getting from VB6 to Access 2000 DB
I am using VB6 professional on a WinNT computer, and I have had no trouble using commands such as
Set db = OpenDatabase(location)
Set rssch = db.OpenRecordset("schedule ")
These commands are fine as long as I use them with Access 97 or previous versions, but with Access 2000, which I am supposed to be using, the error that comes up is that the database is unsupported. I installed the new mdac from microsoft, and that didn't do anything. I am connecting to the database simply through these kinds of commands, not through a data control or odbc, or ADO either. Thank you.
Set db = OpenDatabase(location)
Set rssch = db.OpenRecordset("schedule
These commands are fine as long as I use them with Access 97 or previous versions, but with Access 2000, which I am supposed to be using, the error that comes up is that the database is unsupported. I installed the new mdac from microsoft, and that didn't do anything. I am connecting to the database simply through these kinds of commands, not through a data control or odbc, or ADO either. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Answer is simple when using Access 2000 you must reference DAO 3.6. Reference it and your trouble should be gone.
ASKER
I don't know how you found that page. I searched all over microsoft and altavista and ask.com, not a thing. Must have been searching for the wrong stuff. ANyways, thanks a lot for the help!!