Converting from Access 97 to Access 2002

[Dick Berg]

In 97 I declared variables for database and recordsets
then use the Set to open the recordset. These same lines
in 2002 give errors. Here are Dim statements I used in 97:

Dim dbs As Database
Dim rs As Recordset
Set dbs = CurrentDb
Set rs = dbs.OpenRecordset("checkin", dbOpenTable)

 

[Allen Browne]

From any code window, choose References from the Tools menu.

Check the box beside:
Microsoft DAO 3.6 Library.

Careful: the ADO library also has a Recordset object. More info:
http://allenbrowne.com/ser-38.html