How to disable attempt to repair a corrupt DB message?

R

Ralph

End users are destroying my databases when they attemp to repair the DB by
themselves.
 
J

Joan Wild

Create a custom menu that doesn't include the Compact and repair item
(perhaps the whole tools menu).

Lock down the mdb so that only this custom menubar is available and the
database window isn't, etc. Have a look in Tools, Startup.
 
R

Ralph

Thanks, but let's say the DB is really corrupt. When a user tries to open
this DB, Access has a Startup window that gives the user the option to
"Repair the Database".

Can that prompt or option be disabled?
 
J

Joan Wild

I don't think so, however it sounds as though you have a single mdb that
everyone is accessing.

You should split it. Put the backend (mdb with tables/relationships only)
on the server, and give each user a copy of the frontend (all other objects,
with tables linked to the backend).
 
Top