I would like to update the path to a Linked Table with VBA.
Is this possible? An example would be most useful.

The rest of the story…

I recently started working for a small firm. They have no separation
between Production files and Test files. I am trying to introduce this
concept with a small system that is built with Access 2007.

I would like to have two backend databases with Linked Table paths such as -

Server\TEST\Orders
Server\PROD\Orders

I would like to plug in “TEST” or “PROD” into these paths with VBA code.

Also, if you have more advice regarding the separation of Production from
Test, I am all ears :-)


Thanks in advance for your ideas.


Brad

Yes, this article should get you started.
http://www.mvps.org/access/tables/tbl0012.htm

Its a fairly common task that does come up frequently.

"Brad" wrote:

> I would like to update the path to a Linked Table with VBA.
> Is this possible? An example would be most useful.
>
> The rest of the story…
>
> I recently started working for a small firm. They have no separation
> between Production files and Test files. I am trying to introduce this
> concept with a small system that is built with Access 2007.
>
> I would like to have two backend databases with Linked Table paths such as -
>
> Server\TEST\Orders
> Server\PROD\Orders
>
> I would like to plug in “TEST” or “PROD” into these paths with VBA code.
>
> Also, if you have more advice regarding the separation of Production from
> Test, I am all ears :-)
>
>
> Thanks in advance for your ideas.
>
>
> Brad
>
>
>