Relative path for linked tables

T

Tom Hanley

I am playing around with splitting my database but I want the frontend to look in the current directory for the backend linked tables. Can this be done?
 
K

Klatuu

You can put the back end database any where you want to. When you first
split the database, it will ask you where you want the back end to be. You
can change it manually by using the Linked Table Manager, or programmatically
by iterating through the TableDefs collection and changing the Connection
property of all linked tables. Tables that are not linked will not have a
connection string and when queried for it will return a null string.
 

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

Embedded Excel into Word with Tables 0
Sorting Multiple Tables 1
Adding data to MS Access from csv file 0
AddPicturesToShapes 0
Doughnut Chart linked with the slicer in the pivot table 0
Embed the same Excel multiple times 0
Backend Database 8
Linked Tables 3

Top