Compact and Repair

[y770]

I need to compact and repair shared database file. The database is in use all
the time. I have a routine that identifies current users, but I still need to
run across large company to ask them to log out. Meanwhile, other users
login.:-(
Can I (thru VBA or otherwise) log them out, so I can do meintenance on the
mdb file.
If the answer is 'NO' (which I suspect), what is my other options.
I have already split the file into front end and backend mdb files.

Thanks in advance.
y770

 

[Daniel Pineault]

Take a look at

http://www.rogersaccesslibrary.com/TableOfContents3.asp#L

Specifically the 'LogUsersOff.mdb ( intermediate )' sample database.

 

[y770]

Take a look at

http://www.rogersaccesslibrary.com/TableOfContents3.asp#L
Specifically the 'LogUsersOff.mdb ( intermediate )' sample database.
Hope this helps,
Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.

I did not try this yet, but it looks like it will work

Thanks a lot.
y770