multiple access databases

[Guest]

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

 

[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

 

[Joseph Meehan]

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

Depending on what you really want, you may want to set up one or more
split databases. You can make a "front end" database and then link to the
"back end" database(s) Look up split database.

 

[Guest]

Thanks!!!