Deleting links without deleting the table.

Access suggests that one can delete a link to a table without deleting the
table itself. I have never been able to do this. I cannot export an .mdb file
without having the link follow, and thus force another user to use the linked
table manager to resolve. Has anyone had a problem with this and have found
the solution?

If you have linked to table (another Access .mdb file, a SQL Server table,
or ...), deleting the link in your front-end only deletes the link to the
table.

If you have created a link using a network "share" (e.g., "N\:", "Z\:",
....), other users of your front-end may not have the same "shares" defined.

A useful alternative is to create links using UNC: \\server\path
With this approach, anyone who's PC can "see" the server can use the link.

Or have I misunderstood your question?

--
Good luck

Jeff Boyce
Access MVP

How can I link to tables using the UNC path?



"Jeff Boyce" wrote:

If you have linked to table (another Access .mdb file, a SQL Server table,
or ...), deleting the link in your front-end only deletes the link to the
table.

If you have created a link using a network "share" (e.g., "N\:", "Z\:",
....), other users of your front-end may not have the same "shares" defined.

A useful alternative is to create links using UNC: \\server\path
With this approach, anyone who's PC can "see" the server can use the link.

Or have I misunderstood your question?

--
Good luck

Jeff Boyce
Access MVP