Open Access from Access

T

Tim

Is it possible to open one ms-database from another? I
have 6 small ms-databases that I would like to create a
main form with links to open each database.
Thanks
 
P

Paul Overway

You might want to look into creating library databases. You'd have 1 main
database with references to the other 6. You could then call routines in
the libraries to open forms, reports, whatever within the same instance of
Access. Check out Good Works on our web site. It has 9 libraries.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;143270 for more
info.

You could also use Shell and open another instance of Access.
 
A

Adam

Yes, it is possible. The way you do it depends on what you want to do.

If you simply want to open a database as if the user had opened that
database manually, you can use the FollowHyperlink method in your code.

If you want to read or change the data in another database, you can refer to
other databases in VBA code. This lets you do whatever you want with the
other database 'behind the scenes' without having it visibily open, and your
original database is in control.

HTH

Adam
 
Top