Accessing multiple Access databases

[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

 

[Jonathan Parminter]

-----Original Message-----
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
.

Hi Bruce,
The Access Web may provide ideas for a solution to relink
tables...
http://www.mvps.org/access/tables/tbl0009.htm

Luck
Jonathan

 

[Guest]

Thanks, Jonathan. Will give it a shot.
Bruce

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