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
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

Thanks, Jonathan. Will give it a shot.
Bruce

"Jonathan Parminter" wrote:

>
> >-----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
>