Creating/Destroying Linked Tables

[LarryP]

I have a front end app (~90 users) where, as certain
events occur, I need to create a link to a table in
another Access database, then delete it after the user has
done what he needs to in that table. (Leaving the link
open continuously sometimes creates multi-user conflicts.)

I've written somewhat similar code to link to Excel files,
but that was a RefreshLink situation -- linked table
always present, source changed via code. I've browsed
through this Newsgroup and read what I could find in
Litwin & Godwin, but it still eludes me. Can anyone point
me to a code sample that I can shamelessly plagiarize?

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"LinkTables.mdb" which you can shamelessly plagiarize.

 

[Pat hartman]

Leaving the table linked won't cause any conflicts. There is no active thread unless there is an open RecordSource based on the linked table. Your problem is somewhere else. You don't need to create/destroy the link on the fly.