OpenRecordset etc. Access 2000

[harding]

I'm updating a database that was created in an older version.

In that database, I had created a recordset in order to perform some searching through a table, etc.

Before, I successfully used the pattern:

Dim dbs as Database
Dim rstX as Recordset
Set dbs = CurrentDb
Set rstX = dbs.OpenRecordset("tblDATA&quot
' do stuff
rstX.Close

etc.

This doesn't seem to work anymore. The help files are a bit confusing. Can someone give me an Access 2000 equivalent of the above? I'm having some trouble with the new object / method conventions.

Thank you.

 

[thekon]

Dim dbs as DAO.Database
Dim rstX as DAO.Recordset

may solve the problem

 

[harding]

Thanks thekon.
Your answer didn't work at first, but led me down the right path. (I didn't have the DAO object library referenced in the first place). All works now. Thanks again.