Changing database path for linked table from VBA code

G

Guest

Hi
I need to be able to change the path and database of a linked table between
different tables that each contain the same table.
Is there a way of doing this in the VBA code?
I have looked at the MSysObjects system table and although it the fields
seem to be in here (the Database field contains the database path), I cannot
update this field as it is part of a replica.
Any ideas would be very welcome.
Thanks.
Sarah
 
D

Dave Patrick

This may help you.
http://www.mvps.org/access/tables/tbl0009.htm

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi
| I need to be able to change the path and database of a linked table
between
| different tables that each contain the same table.
| Is there a way of doing this in the VBA code?
| I have looked at the MSysObjects system table and although it the fields
| seem to be in here (the Database field contains the database path), I
cannot
| update this field as it is part of a replica.
| Any ideas would be very welcome.
| Thanks.
| Sarah
|
 

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

Change drive letter in linked table manager 5
Modify Linked SQL table in Acess via VBA code 7
determining directory of linked file and using path as variable in 3
Path to linked table 2
How to connect to a BE database? 0
Update Link Table Path in Code 2
Can a “Linked Table†path be updated with VBA? 1
Change Path Name for Outlook Linked Table 4

Top