Accessing multiple Access databases

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

Guest

Hi, all!

We use multiple Access 2000 databases, one for each client. All have identical tables, fields, etc. From a separate Access database, I need for the user to browse to one of the Client databases, select it, then my VBA code will perform certain tasks.

Those tasks include using data stored in one of the Client (Select query), computing results, then posting back to a second table in the Client database via Update and Append queries.

I'm using the API FileOpen to allow the user to select the database and provide me with the network path, but have never worked with mutiple Access databases from a single application. Can someone provide rough code on how to connect to the selected Client database and provide any pitfalls I should look out for?

Thanks,
Bruce
 
-----Original Message-----
Hi, all!

We use multiple Access 2000 databases, one for each
Click to expand...
client. All have identical tables, fields, etc. From a
separate Access database, I need for the user to browse to
one of the Client databases, select it, then my VBA code
will perform certain tasks.
Those tasks include using data stored in one of the
Click to expand...
Client (Select query), computing results, then posting
back to a second table in the Client database via Update
and Append queries.
I'm using the API FileOpen to allow the user to select
Click to expand...
the database and provide me with the network path, but
have never worked with mutiple Access databases from a
single application. Can someone provide rough code on how
to connect to the selected Client database and provide any
pitfalls I should look out for?
Thanks,
Bruce
.
Click to expand...
Hi Bruce,
The Access Web may provide ideas for a solution to relink
tables...
http://www.mvps.org/access/tables/tbl0009.htm

Luck
Jonathan
 
Thanks, Jonathan. Will give it a shot.
Bruce

Jonathan Parminter said:
client. All have identical tables, fields, etc. From a
separate Access database, I need for the user to browse to
one of the Client databases, select it, then my VBA code
will perform certain tasks.
Client (Select query), computing results, then posting
back to a second table in the Client database via Update
and Append queries.
the database and provide me with the network path, but
have never worked with mutiple Access databases from a
single application. Can someone provide rough code on how
to connect to the selected Client database and provide any
pitfalls I should look out for?
Hi Bruce,
The Access Web may provide ideas for a solution to relink
tables...
http://www.mvps.org/access/tables/tbl0009.htm

Luck
Jonathan
Click to expand...
 
Back
Top