DAO.recordset Application ERROR 1

[BarryBolin]

I have a database that I have copied from work to home to do some coding on.
At work using standard Recordset declerations all my VB code using recordsets works fine. at home when ever I try to use any of my code with Recordsets in it they fail due to the error "User Defined type not defined" yet another database from work has no problems.
PLEASE what am I missing in theis database?????

 

[formerTexan]

Hello Barry,

IF you are using A2K or a later version at work, you will need to set the code library reference for Microsoft DAO 3.6. Access will no longer do it for you. My guess is that your problem will then clear up.

Cheers,
Bill

 

[BarryBolin]

Perfect. Found the entry in question and added it. Funny thing is to find this resource entry. Works great thanks.