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.
theravada_mahaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
bruintjeConnect With a Mentor Commented:
0
 
MarineCommented:
Answer is simple when using Access 2000 you must reference DAO 3.6. Reference it and your trouble should be gone.
0
 
theravada_mahaAuthor Commented:
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!!
0
All Courses

From novice to tech pro — start learning today.