FIND THE ANSWERS

MS Access VBA tools -> references... I use Access 2000. How do I know which one(s)??

Answer this question

  • MS Access VBA tools -> references... I use Access 2000. How do I know which one(s)??


Answers

Answer #1 | 28/12 2013 21:22
I use Visual Basic For Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft DAO 3.6 Object Library My understanding is that you don't need something unless you need something. In other words, if something doesn't work, you research it and find that it says you need to add a library to make it work. Maybe it would take longer to startup or to load a form if you checked everything.
Answer #2 | 29/12 2013 06:23
You can use the version of the access engine that is available in the references in your project. You'll also need to add a reference to the Microsoft DAO 3.6 Object Library (whichever version you have installed is fine, since the code in the video is pretty generic). You definitely don't want to check everything, especially if you ever intend on sharing the database: each reference you check refers to a .dll/.ocx file that exists on your pc, which you cannot guarantee exists on any other PCs. You'll want to stick with standard .dll files that are installed with Office.

Possible answer