Locking Forms and Reports from user modification

J

Jacqueline

I have a split database. I am the only one that is suposed to make
modifications, however there is a person with same access and privildge that
I have that thinks they need to change and or modify my reports or forms from
time to time.

Is there a way to lock a form and report from allowing modifications to
design?

Thank you,
Jacqueline
 
J

John W. Vinson

I have a split database. I am the only one that is suposed to make
modifications, however there is a person with same access and privildge that
I have that thinks they need to change and or modify my reports or forms from
time to time.

Is there a way to lock a form and report from allowing modifications to
design?

Thank you,
Jacqueline

Create a .mde file from the frontend. Give them the .mde and keep the .mdb in
a safe place (a CD locked in your desk drawer if need be!)

They won't be able to make design changes in the .mde.

Alternatively, give them their own .mdb frontend and let them make whatever
changes they want, at their own risk; keep the "official" .mdb for everyone
else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top