Security in a form

J

JLS04

I've developed an Access form where users will enter data. Is there a way to
put security in place so users can't get past the data entry screen?
 
K

Keith

JLS04 said:
I've developed an Access form where users will enter data. Is there a way
to
put security in place so users can't get past the data entry screen?

Yes, you need to hide the database window, apply user-level security,
provide custom menus and close back doors such as the "Bypass" key (holding
<shift> at startup). This is by no means a trivial task. You could employ
someone to do it for you (could be expensive) but if you wanted to get to
grips with security then the place to start is the MS FAQ. There's a link
to it on my web site - be warned, *all* of the steps must be followed in
sequence, omitting nothing. There's also a link to my step-by-step example
that might help you understand.

Here's the best piece of advice you'll receive on here: back up your files
first in case you lock yourself out (very easily done).

HTH - Keith.
www.keithwilby.com
 
J

JLS04

WOW! Thanks Keith. I'll do my best!

Keith said:
Yes, you need to hide the database window, apply user-level security,
provide custom menus and close back doors such as the "Bypass" key (holding
<shift> at startup). This is by no means a trivial task. You could employ
someone to do it for you (could be expensive) but if you wanted to get to
grips with security then the place to start is the MS FAQ. There's a link
to it on my web site - be warned, *all* of the steps must be followed in
sequence, omitting nothing. There's also a link to my step-by-step example
that might help you understand.

Here's the best piece of advice you'll receive on here: back up your files
first in case you lock yourself out (very easily done).

HTH - Keith.
www.keithwilby.com
 

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