If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
table of contents - page links | tndmrx | General Discussion | 8 | November 11th, 2004 12:11 AM |
Deleting links in Table of Contents | Sue O'Donnell | General Discussion | 2 | September 15th, 2004 05:20 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |