OpenRecordSet("tablename") in Access 2000

[Karljuergen]

Hi

I'm migrating from Access 97 to Access 2000, and experiencing some difficulties.

In particular, the following code (in preparation for a simple loop through)

Dim LRst As Recordset
...
Set LRst = CurrentDB.OpenRecordset("Table&quot

which worked fine in Access 97, gives a type mismatch. Specifying all the optional parameters doesn't seem to make any difference. Searched help all day and got nowhere.

Any assistance would be appreciated.

K

 

[TTThio]

Check your tool - reference, make sure the DAO 3.6 is selected instead of MS ADO 2.1

 

[Karljuergen]

Eventually figured out I ought to try turning on DAO 3.6, but that didn't work either... until I turned off ADO 2.1 as you suggest.

Thanks!

 

[Guest_imported]

May be your problem is because you to declare the variable
like this:

Access 97
dim rs as recordset

Access 2000

dim rs as DAO.recordset


luler@hotmail.com