How to Open An Access File while Using Another

26-October-2021
People sometimes ask, “how can I open a different database file from my app that I’m building, so that I can make changes or lookup data?” This is a really good feature in MS Office that we can use native libraries to open Word documents or Excel files to manipulate in our VBA. Access is no different, so you can easily open an Access database from your own Access app code if you want. In fact, you can open it from your Excel or Word code as well! The answer lies in using the Access application object; today we’re going to do just that!



MS Access Project? Contact me today!