Can a “Linked Table†path be updated with VBA?

[Brad]

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

 

[David H]

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.