opening another database

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

Guest

Is there an easy way to open one database from another and maybe even pass it
some information? I do not think I want to combine the seperate databases.

Any help would be appreciated.

Thanks

Don
 
You can open a database like this:

Dim dbs As DAO.DAtabase
Set dbs = OpenDatabase("PathToYourDatabase")
 
Ok, I tried that and I get an error message:
"Compile error: User-defined type not defined".

I am guessing that I don't have a library loaded? If so, which one and can
I load it as part of the code or do I need to go to every pc that accesses
the database and load it?
THanks again
 
If you want to send informatoin from one database to another it's not
normally necessary to open the second one. You can use linked tables in
one database to access tables in another (File|Get External Data|Link).

Alternatively you can create queries that connect directly to tables in
another database, using an IN clause in a SQL query (look for it in Help
under "Microsoft Jet SQL Reference").
 
Back
Top