How to Open Another MS Access Database from Your Database

preview_player
Показать описание
How to Open Another MS Access Database from Your Database
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!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#AccessVBA #OpenDatabase #SeanMackenzie

Рекомендации по теме
Комментарии
Автор

Would i be able to open a form in the other databass & call it my recordset or do i just use the OpenForm cmd?

June-trhg
Автор

It works to close the actual database and open another?

dejesushernandezalan
Автор

Please can you share the VBA-Code lines? Thanks a lot in advance.

nameisunimportant
Автор

Very useful tips sir. Please create a project how to send sms using ms access vba.

ahsanhabib
Автор

Handy one
I will Try to use this method to move records more than 5 weeks old to another db

gerfer
Автор

Nice video. I wonder if you can post a similar training video to launch an access database application from another database then once the access db is open, the caller gets closed. That'd be a cool video training to have.

GinoFerreri
Автор

Thanks, Sean, for another useful topic.
I would enjoy your videos much more if you did not rush through them. Most of these topics deserve more attention to details other than comments that there are other ways to do this, but you don't need to know this.

bumpersmith
Автор

How do I create a command button on one database to open the other database? Do I just call this module?

bradweekley