Hi,

I wanted to set user previlege via user group and password
where I want only certain user/group who could have access
to certain tables/report. How do I do this? Thanks.

regards,

zainuddin

It sounds like you need the user-level security wizard. It is quite well
described in the Access help files, which should tell you everything you
need to know.

HTH

Adam


"zainuddin" <(E-Mail Removed)> wrote in message
news:0aa301c36bac$fa282df0$(E-Mail Removed)...
> Hi,
>
> I wanted to set user previlege via user group and password
> where I want only certain user/group who could have access
> to certain tables/report. How do I do this? Thanks.
>
> regards,
>
> zainuddin

This is not just a password function.

Some people have programmed using VBA to get something like you are
asking about. The simple password security in Access is just not up to the
task. User level security is the tool Access offers for this.

If you want real security then 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


"zainuddin" <(E-Mail Removed)> wrote in message
news:0aa301c36bac$fa282df0$(E-Mail Removed)...
> Hi,
>
> I wanted to set user previlege via user group and password
> where I want only certain user/group who could have access
> to certain tables/report. How do I do this? Thanks.
>
> regards,
>
> zainuddin