Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: upgrading to 2000


Message #1 by "Lloyd Levine" <levinll@m...> on Mon, 22 Apr 2002 12:47:20
Cut my teeth on Access 97 and now I'm upgrading some apps. to 2000. I have 
the following question.

In 97 if you wanted to open a recordset you would use the following code:
Dim rc as Recordset
Dim db As Database

Set db = currentdb
Set rc = db.openrecordset(Query/Table Name)

Am I correct that under 2000 the following code is needed:

Dim rc As DAO.Recordset
Dim db As Database

Set db = Currentdb()
Set rc = db.openrecordset(Query/Table Name) 

Thanks !

  Return to Index