Open one Database from another database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to open one database from a master database.

I'm not sure where to begin looking for help on this. I've tried looking
under open but get the one context. Any ideas?
 
Are you really interested in opening the other database, or just using some
of the data from the 2nd database in the first application?

If you want to do the latter, you can link tables from one to another. If
there is code in the second database that you want to use in the first, you
can make the 2nd database an add-in and use the Tools-References to "link"
the two databases, allowing you to run code in db#2 from within db#1.

If you just want to open the 2nd database, you could use the Shell( )
function to open another instance of Access and open the file, something like:

RetVal = Shell("MSAccess C:\TEMP\2ndDatabase.mdb", 1)

Or you could probably use the FollowHyperlink method

application.FollowHyperlink "C:\Temp\2ndDatabase.mdb"

HTH
Dale
 
It's a tough decision really. I have several databases that need to be
updated. Do I bypass opening each database and just update the tables
individually or do I open each database and watch the process?

It's hard to let go of a process when you don't know what's happening and
want to watch it to make sure it's doing its job.

I think I want, in the end really, is to just up date the tables.

I'll need to think about the logic but I think I'll just link them and do it
that way.

Thanks
 
When I use data from one application, in another one, I always link it, so I
don't have to update the tables in more than one location.

Good luck.
 
Back
Top