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.

 

[Pat Hartman]

The current version of Access defaults to DAO (and I hope it stays that way) I think A2K defaulted to ADO and that caused enormous problems.

As the others suggested, disambiguate all DAO objects to avoid current and future conflicts. ADO and DAO have some overlapping objects and so not disambiguating the Dim statement will result in the interpreter using the first library defined that has the object. So if you have a reference to ADO in addition to the default reference, which ever is first in the reference list will prevail so just avoid the conflict from the get go.

 

[Isaac]

3 people now agreeing with my original post - flattering!