Open Access from Access

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
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.
 
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
 
Look at "File" "Get External Data" "Link Tables" See if that is what
you want. You can link to a table in another Access Database and then use
it as if it were in your own database. The data is updated as you or others
update it.
 
Back
Top