security on tables

[SalimShahzad]

dear gurus,

can any one put lights how can one put security to open table for
client users...

as i wanted to only open forms/report rest all object should be kept
locked...even by accessing/design mode should not allowed

as some of our smart users has deleted data even having relation ship
parent/child...what happend access 2003 has allowed to delete any kind
of table even uppper/lower relation exsisit rest till access 2000/XP it
never allowed

v had lost data sir can any one help plzzzzzzzzzzzzzz

thanks you in advanced
shahzad

[Madhivanan]

Protect with password

Madhivanan

[Keith]

"SalimShahzad" <sa**********@gmail.com> wrote:

can any one put lights how can one put security to open table for
client users...

as i wanted to only open forms/report rest all object should be kept
locked...even by accessing/design mode should not allowed

as some of our smart users has deleted data even having relation ship
parent/child...what happend access 2003 has allowed to delete any kind
of table even uppper/lower relation exsisit rest till access 2000/XP it
never allowed

v had lost data sir can any one help plzzzzzzzzzzzzzz

You need to apply user-level security which is far from being a trivial
task. See my web site for a link to the MS Access FAQ on security and a
step-by-step example.

Remember to work on COPIES of your files.

Keith.
www.keithwilby.com

[SalimShahzad]

Thanks you sir i will look into it...

regards,
shahzad