Link two Jet tables in VBA

R

rmcompute

I have to go into several applications and re-link specific tables with:
Tools/Database Utilities/Linked Table Manager, select the tables, and select
the database which they should be linked to. All are Jet databases. Is
there an easy way to set up a program in VBA which can accomplish the same
thing programatically ?
 

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

How to create portable Excel applications? 2
ASK Field Formatting 1
Linking tables 0
Auto refresh linked excel table from access database 3
Annoying Invalid path message from Link Specification 2
Linked Table Manager works one at a time 4
How to, using Excel VBA, link a text file to a .mdb file? 0
How to populate other fields when a dropdown was changed 13

Top