OpenDatabase

[Joe]

Hello,

Can I Open a database from another Database and Make
query in the second DB from the first

Open DBClient.mdb from DBVendor.mdb and make Select query
and Update Query in DBClient.mdb for tables in
DBVendor.mdb

I tried docmd.OpenDataAccessPage but it not seem working

Thanks very much for help

 

[Kelvin]

You do not need to open another database to perform the query. You can
either link the other table to your database or modify your query. There is
a standard SQL format to access tables and queries in other databases.

SELECT * FROM table IN 'path_to_other_file.mdb';

Kelvin Lu

 

[news.east.earthlink.net]

Why not link the tables you need to update? Then you can work with the
information as if it were in the current working mdb.