MDE Exclusive opening back-end data file

[Jonathan]

Hi,

I have a split database where the data is in a MDB file on a server and the
application to work on these data is compiled in a MDE file distributed to
the users. The application uses linked tables. I would like the
administration of the data (compact, back-up, etc) to be done from the MDE
file, in order to prevent anyone to access the MDB file directly. I have 2
problems.

1) How can I, as an administrator, get the exclusivity on the MDB file from
the MDE file?

2) Can I close the connection between the MDB file and the MDE file without
removing the linked table from the MDE file?

Thanks a lot!

Jonathan

 

[Douglas J. Steele]

1. I don't believe there's any way to force exclusivity. AFAIK, the best you
can do is check whether or not the locking file (.ldb) exists in the same
folder as the .mdb

2. As long as you're not using any of the tables (i.e.: no bound forms are
open), there should be no connection (i.e.: the .ldb file shouldn't exist
even though you're in the .mde)

 

[Jonathan]

Hi!

1. Ok, I'll dig the idea.

2. Oh, thanks. I knew about the bound forms, but your comment led me to
realise that a combox displaying a query had the same effect.

Thanks again,

Jonathan