Compact and Repair

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

y770 - 12 Feb 2008 23:31 GMT

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

Reply to this Message

Daniel Pineault - 13 Feb 2008 00:44 GMT

Take a look at

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

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

Signature

Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.

> 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
[quoted text clipped - 7 lines]
> Thanks in advance.
> y770

Reply to this Message

y770 - 13 Feb 2008 00:58 GMT

> 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

Reply to this Message