Two users in the same database at the same time

"David W. Fenton" wrote in message
36.89...
"Douglas J. Steele" wrote in
:

if you have code that relies on the non-existence of the file,
you'll run into problems...

In that case, you can convert your code to try to delete the LDB
file. If it's in use, you'll get a trappable error.

Even if you don't have Delete permission?

Or will it be a different error if it's in use than if it isn't?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Douglas J. Steele" wrote in
:

"David W. Fenton" wrote in message
36.89...
"Douglas J. Steele" wrote in
:

if you have code that relies on the non-existence of the file,
you'll run into problems...

In that case, you can convert your code to try to delete the LDB
file. If it's in use, you'll get a trappable error.

Even if you don't have Delete permission?

Or will it be a different error if it's in use than if it isn't?

Good question!

Maybe the real way to do it is to actually not use the LDB file as a
proxy for someone having the MDB open, and instead use the Windows
API to check if the MDB is actually open:

http://vbnet.mvps.org/index.html?cod...file_inuse.htm

I can't endorse the code there (I've never used it), but it's a
start.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/