Reference to Activate Variable as Database

[JithuAccess]

Hello Guys,

Which Reference I should Activate to view Database and Recordset properties in Code Window. When I am trying to declare the variables I am getting like this:

Thanks

 

[JithuAccess]

Got it

MS DAO 3.6

 

[Isaac]

I'd leave the default references (don't add anything), and use DAO.Database, DAO.Recordset, etc

 

[Minty]

That DAO reference has been depreciated. Use the Mircosift Office Access database engine objects instead ;

 

[theDBguy]

Got it

View attachment 88909

MS DAO 3.6

Which version of Access are you using? You must have taken something out to be able to add that in.

 

[JithuAccess]

Which version of Access are you using? You must have taken something out to be able to add that in.

MS Access 2016.

Thanks

 

[theDBguy]

MS Access 2016.

Thanks

In that case, you didn't have to add the 3.6 library because, as @Minty said, the DAO library is already included in the ACE library.

 

[Isaac]

3 people now agreeing with my original post - flattering!