Can a "Read-Only" user corrupt the DB by turning off workstation?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AndyG - 16 Jul 2007 14:32 GMT

Although we try to educate our users, however, as some are more impatient
than others, I would like to know if it is possible to corrupt the db by a
user with read-only permission turning off her/his workstation while they
have th Access application (and linked db) open?

Reply to this Message

Tony Toews [MVP] - 17 Jul 2007 00:29 GMT

>Although we try to educate our users, however, as some are more impatient
>than others, I would like to know if it is possible to corrupt the db by a
>user with read-only permission turning off her/his workstation while they
>have th Access application (and linked db) open?

No.

A client with 25 users on all day long has had several power failures
where the server was on a UPS and the client systems were not. They
never had a corruption due to a power failure.

The flag indicating corruption is set by Jet, not Access, when a
client program, be it Access, VB, or whatever, using the Jet dlls
starts to do an update to the MDB be it a new record, update or
delete. It is reset once the update is finished. If the update fails
then the flag isn't reset.

This isn't part of your question but I thought I'd mention it anyhow.
Now the interesting thing about this flag then is that users currently
in the database happily keep working away completely oblivious to this
flag being set. Any new users who attempt to open the MDB however
will get the compact and repair message.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Reply to this Message