Opening a second mdb file from an open mdb file

[Wink20TCU]

I have two mdb files (one used for general department use and the other for
detailed reporting). For ease of maintenance, I'd like to keep these mdb
files separate, but I would like to have the ability to open the second mdb
file from the general dept Access program.

Is there an exisitng macro or VBA code I could use to accomplish this task?
Thanks for your help.

 

[Arvin Meyer [MVP]]

Sure, you can easily just shell out to another app:

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

or even create a hyperlink that opens the file. Just create a label, go to
the property sheet and enter a path in the hyperlink address property.