Method or data member not found

B

BvB

I have two identical ACCESS databases with the references set identically.
Both database use the "AddNew" action to add a new record to a Recordset.
Compile the new database and I get "Method or data member not found".

Any assistance would be appreciated - Thank you.
 
J

Jedi022694

There are two Object Libraries that Access uses: DAO and ADO, where both have
a Recordset object. Access will use the first one it finds in the References
List, unless you specify which you want. So, you can do one of two things:

(1) Change your Dim statement to: Dim rst As DAO.Recordset. OR

(2) Go into References (Menu: Tools|References), while in the MS-Access code
editor, and place a check next to "Microsoft DAO 3.6 Object Library" and move
it high on the list. This will also work better if you if the Dim statement
gives you
a compile error.

Good Luck,
Jedi022694
 
Top