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

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shell Puzzler - “Documents and Settings†folder issue? 5
Access 2007 Append Query – Issue with automatically inserted brack 3
Table Def “Connection†info (Database Name) 4
change connection string to linked table with VBA 10
Can “Access 2007†Access Remote SQL-Server? 2
Referential Integrity – Import of Data from a purchased package 6
Access 2007 Application for Reports Only – SQL Server Security 3
Using VBA, How Can I Replace A Character In A Field? 4

Top