Kick users, Compact and repair, create backup, auto compact on close?

[charliemopps]

I have an Access database that's split into front and backends.
Every once in a while the back end gets messed up and only a compact and repair will fix it.

When this happens, I notice that the lock file is still in the folder. I think what is happening is someone is shutting down their computer without exiting the database.

In any event, I need to come up with a way that users can repair the DB when I'm not here.

I want a window to pop up that says:
Open Database
Repair Database

The form would be unlinked so it wouldn't crash when the backend it screwed up.
When the repair button is clicked, I want it to kick off any logged in users and repair the BACKEND of the database (not the frontend)

I'd also like the database, when it is closed, to check if there are other users logged in, and if not, run a compact and repair. (so the last user to log out would be repairing it.)

I know this subject is talked about a lot. But I did multiple searches and could find no code examples. If anyone has information on this subject I'd appreciate it.

 

[RuralGuy]

To start with I would implement a "If not being used, log off the system" routine.

 

[asif pasha]

That was interesting part. Thanks.

However do you similar kind of sample database for A97.

Reason we use A97 in office, and offten i have inform the user to close the DB, if i have something like i open the form and the instruction to close the db it should automatically close the db after X min which i entered. Also it should send a message to the user.

Secondly : Can i track the users logged in the DB in A97 with the Username?

Thanks in advance

 

[RuralGuy]

I have no experience with ac97, sorry. Have you tried using the ac2k stuff? I think it might work.