Check references/open procedures to backend.mdb (please, heeeelp! ;-)

[Daniel Roth]

Hello everybody,

I have a rather tiring problem with my Access XP database:

I split the database in two: one ist called frontend.mdb and contains a main
form ("frmMain"), which for example enables the user to import multiple text
files dynamically into the database (the table itself is stored in the
second piece: backend.mdb) or link the previously imported table to the
frontend.mdb:

DoCmd.TransferDatabase acLink, "Microsoft Access", _
backend.mdb, acTable, "tblDummy", "tblDummy", , False

The form "frmMain" enables the user also to delete a specific table (can be
chosen from a listbox): I first delete any linked table in the frontend.mdb
and then try to delete the table in the backend.mdb : DROP TABLE tblDummy -
but sometimes (and only sometimes) access to the remote table is not granted
(the table is locked) and I cannot delete the table - only when I close the
whole frontend.mdb (the Form "frmMain" and the application) and delete the
table directly in the backend.mdb, it works (sometimes not even this
works...*).

My questions:

1. Is there any way (with VBA) to first detect and then clear/destroy any
active references/locks/connections from the backend.mdb to the frontend.mdb
so that I in any case am able to delete the table in the backend.mdb?

2. Is there any timeout-sequence that releases the connection
backend-frontend? Sometimes it seemed that after some time I was able to
delete the table *

Any help is greatly appreciated - and by the way: my mother tongue is not
English: I hope I was able to express myself!

Many greetings

Daniel Roth