automatically repair a database

[gerard1979]

Access 2002
front_end/back_end
front_end local on every machine
back_end shared in a network

problem:
Sometimes the back_end corrupted, after clicking on the back_end file the database asked for repairing. I'll repair it, no further problem. But what I want: A shortcut for repairing, so the user can repair the file by itself, every warning must be disabled, so only a shortcut for repairing.
Somebody know if it's possible an how?
Thnx in advance,

Gerard

 

[Craig0201]

Gerard,

I wouldn't give a user this sort of functionality. It's the sort of thing an administrator should be doing.

Craig