multiple access databases

J

John

Is it possible to set-up a Master Menu Form (switchboard) that can work with
several different Access databases? For example:

Master Menu button1(click) and it goes to a form in database2
Master Menu button2(click) and it goes to a report in database5
Master Menu button3(click) and it goes to a form in database1
etc...
Many thanks.
John
 
A

Arvin Meyer [MVP]

Certainly, but that is also what a shortcut does. If you want to do it from
Access though, use the following code to fill a table of Access database
names:

http://www.datastrat.com/Download/DocMgr_2K.zip

The above code uses a filter to find Word.doc's, but you can easily change
the filter to find mdb's, then add a column of friendly names. Fill a
listbox with the names and paths, and use ShellExecute to open the
databases:

http://www.mvps.org/access/api/api0018.htm
 
Top