G
Gary
I have my front end and back end of my database separate
and use the Linked Table Manager to link to the backend.
I now wish to use the same front end to different
backends. I may use one backend with table name
tblcustomer for one day. Then I want to relink that same
frontend to a different filename with the table name
tblcustomer. These backends have many tables. Some
tables are on different harddrives for backups. Is there
any way to programmatically relink to a different
backend. By that I mean, can I set up a vb button in
Access that will link certain tables to c:\folder\filename
and link certain other tables to j:\folder\filename.
In other words, I want to automate what you do manually
with the Linked Table Manager.
Thanks very much for the help.
Gary.
and use the Linked Table Manager to link to the backend.
I now wish to use the same front end to different
backends. I may use one backend with table name
tblcustomer for one day. Then I want to relink that same
frontend to a different filename with the table name
tblcustomer. These backends have many tables. Some
tables are on different harddrives for backups. Is there
any way to programmatically relink to a different
backend. By that I mean, can I set up a vb button in
Access that will link certain tables to c:\folder\filename
and link certain other tables to j:\folder\filename.
In other words, I want to automate what you do manually
with the Linked Table Manager.
Thanks very much for the help.
Gary.