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")
 
Is there a way then to pass variable information to the newly opened
database?
 
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").
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opencurrentdatabase (without open a new database) 0
Combine two databases into one 4
Access Command to run access, open to specific form and specific record 1
Open one database from another 4
return function value from another DB? 3
Record-Locking remains open after closing 0
Test if other database is open 10
Connect from one Secured Access DB to another, but different MDW f 3

Back
Top