Changing database path for linked table from VBA code

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
|
 
Back
Top