A
alex
Determine if File is open
Using Access ’03…
I have an mde that copies another mde to a particular drive and then
opens the file.
The first thing it does, however, is look for an ldb to see if the
file is already open. This works fine, but sometimes Access is not
shut down properly (because of network issues, etc.) and the ldb still
exists even when the mde is not open.
Is there another way to check and see if the mde is open other than
looking for the presence of the ldb?
I suppose one creative way would be to look for the ldb; if it does
not exist, the file is not open. If it exits, try and kill it. If
you get an error, the mde is open. Not sure how to trap that error,
however.
Thanks,
alex
Using Access ’03…
I have an mde that copies another mde to a particular drive and then
opens the file.
The first thing it does, however, is look for an ldb to see if the
file is already open. This works fine, but sometimes Access is not
shut down properly (because of network issues, etc.) and the ldb still
exists even when the mde is not open.
Is there another way to check and see if the mde is open other than
looking for the presence of the ldb?
I suppose one creative way would be to look for the ldb; if it does
not exist, the file is not open. If it exits, try and kill it. If
you get an error, the mde is open. Not sure how to trap that error,
however.
Thanks,
alex