table security

  • Thread starter Thread starter SalimShahzad
  • Start date Start date
S

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

i just wanted to know how one can make tables protected...as hideen
method does not work for smart users, even shift by pass is very
easy...

any other ideas

thanks you in advanced
shahzad
 
Hi, Shahzad.

You posted this identical question in another Access newsgroup this morning
and it was answered by several knowledgeable Access security experts.
Someone using your user ID and E-mail address responded by thanking one of
the experts, but the response was from a different computer than the one you
used to post this question and the original question. Nevertheless, this
question has been asked and answered elsewhere, so please don't start a new
thread in a different newsgroup. If you have further questions, such as your
remark about the shift bypass and hidden property not being successful in
securing your tables, then please continue on the original thread.

Thank you.

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
 
Dear Sir,

I am not aware much about this groups as that group whatever they
answer has not solution...

i wanted to stop access of tables for everyuser how can i do that...as
i found the ways to put password on form, login,report etc...hiding vba
codes

i hope you got me...if i got the answer i might not come 2 ur precious
secuirty/time both

if you don't want to answer no problem sir...

thanks anyway
regards,
shahzad
 
SalimShahzad said:
i wanted to stop access of tables for everyuser how can i do that...as
i found the ways to put password on form, login,report etc...hiding vba
codes

The answer is to hide the db window and apply user-level security!
 
Back
Top