Open Access database from within Access database

G

Guest

Everyone,

I have the need to create a database that acts as a master database
containing command buttons to open a variety of other Access databases we
support. This master database will function as a card catalog of sorts and
will be used by 100+ employees.

How do I write the code such that users are not opening an instance of the
second database while keeping the 1st open in memory? The command button
will need to redirect them completely away from the master database and allow
them full function of the 2nd database opened.

Thoughts? I have considered CreateObject, Run, and/or Shell. None of these
methods however seem appropriate for my needs.

Thank You
 
G

Guest

Alex,

Do you know the hard code behind the .dll? Downloading an add-in as such
violates the Security policies of our company.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access how to open existing database from another database using Access - VBA 0
Leave database open 3
splitting database 6
Access Command to run access, open to specific form and specific record 1
Open one database from another 4
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Using VBA to switch to a particular Access database 5
Calling Access 'form' from other applications 0

Top