Open Recordset

[VTbigwillie]

I am currently working with a new Access 2000 format database. In the previous database I worked on the following line of code worked perfectedly:
Set rs = CurrentDb.OpenRecordset("tblShopper", dbOpenDynaset)

In my new database, this line is not working. Is there an option that needs to be turned for this to work? I have no idea what the problem is.

Thanks in advance,
Will

 

[cmmrfrds]

Set a reference to the DAO library. Access 2000 uses ADO data objects (library) by default. Also, good to set explicit references to the data objects to avoid confusion since some objects have the same name in both libraries.

Dim rs as DAO.Recordset