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

 

['69 Camaro]

Hi, Salim.

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

Then you will need to apply user-level security. Read and study the
Security FAQ on the following Web page:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

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

Access 2003 is not to blame. This feature is available in every version of
Access, but relational integrity _must_ be enforced to prevent related
records or tables from being deleted.

Improperly designed databases will result in data integrity issues, as you
have found. The easiest way for this to happen is to split the database into
a front end (queries, forms, modules, et cetera) and a back end (tables and
relationships), then applying the table relationships in the front end
instead of the back end. Relational integrity cannot be enforced on remote
tables, but only on tables located in the current database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering

 

[Keith]

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