I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.
Practice on some copies to make sure you know what you are doing.
--
Joseph E. Meehan
26 + 6 = 1 It's Irish Math
"Emmy" <(E-Mail Removed)> wrote in message
news:0dd401c3665a$044fbc10$(E-Mail Removed)...
> Hello,
> Is there a way to set security on one table in a
> database? I will have a form that is hooked to this
> table, but it needs to ask for a password so only certain
> people can view this information.
>
> Thanks!
> Emmy