Is there a way to see if the BE is being used?

[DubaiDave]

I would like to compact and repair from my FE, but would like to check if anyone else is using the BE first.

DubaiDave

 

[namliam]

Compact the FE, but need to know if the BE is beeing used?? WTF??

Simply check for a LDB though... Any use of the BE (assuming it is in access) should create a LDB file.

 

[DubaiDave]

Hello Again Namliam,

What I want is to have a button on my FE that will compact and repair my BE. I am a newbie - so if this is a daft thing to do please let me know.

DubaiDave

 

[namliam]

Well what I do usually prevent the BE from needing a compact by having any temp tables and such in a seperate BE that gets replaced with empty database where/when needed.

Depending on database size & network speed your compact can take a while.... Theoriticaly you should be able to check for the existance of yourDatabaseBE.LDB.
If that exists then it is is use, if not there, not in use... Keep in mind that during compact NO ONE can use the BE-DB

 

[DubaiDave]

Thanks Namliam.

I have it working now: I have a button on my FE that checks if the BE is in use and, if not, compact and repairs it.

Understand that the BE cannot be used during the C&R process. But there are only a few of us using the dB.

Thanks for your help!

PS Still struggling with this (thanks for your reply on this other thread)

http://www.access-programmers.co.uk/forums/showthread.php?t=179430

DubaiDave