Is it possable?

  • Thread starter Thread starter Laura in MN
  • Start date Start date
L

Laura in MN

Is there a way to sever a link from a linked table?

I am trying to copy a database to test on with out
corrupting the origional linked datasource. I would like
to do this by simply copying the table and deleting the
link, but so far, my research has shown this to be
impossible.

Any ideas?

Thanks.
-L.
 
You can copy the backend database as well (assuming it's a mdb). Put it in
a separate test location.

Then you can use Tools, Database Utilities, Linked table manager to change
your links to the test backend (be sure to put a check in the bottom of that
dialog to prompt for the new location).

When you've finished testing, you can relink back to the live data via the
same method.
 
Laura in MN said:
Is there a way to sever a link from a linked table?

I am trying to copy a database to test on with out
corrupting the origional linked datasource. I would like
to do this by simply copying the table and deleting the
link, but so far, my research has shown this to be
impossible.
Click to expand...

Delete the link and them import the source table.
 
Back
Top