Problems in Access 2000 vs. Access XP

J

Jenny

Hi,
I've developed a database using XP (in file format 2000).
My client is using Access 2000 to open my database. It
has some problem in compliing the following code.

Dim db As DAO.Database
Dim rstqry As DAO.Recordset
Set db = CurrentDb()
Set rstqry = db.OpenRecordset
("qryDiabGroupIDSelect",dbOpenDynaset)

It highlighted on dbOpenDynaset and gave the Microsoft
Visual Basic Error Message: Cann't find the object or
library.
I've included Microsoft DAO 3.6 Object Library and
Microsoft Access 9.0 Object Library in Access 2000.
Can any one tell what I should do next to solve this
problem?
Thanks,
Jenny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top