Database Security

D

DB Queen (Not)

I have a database that many people have access to and I want people to be
able to add to that database but I don't want them to be able to change
anything that is in it already. Any ideas?
 
T

tina

do you mean you want people to be able to *add data*, but not be able to
*change existing data*? you can prevent changing data via forms by setting a
form's DataEntry property to Yes when data entry is desired, and setting a
form's RecordsetType property to Snapshot when review of existing records is
desired. you can take various steps to prevent users (at least those who are
not Access- or programming-savvy) from gaining access to the data more
directly via queries and table, but a smart and determined user can get
around these blocks. to *really* secure the data (as much as possible using
Access software), you would need to implement Access security. for more info
on that issue, which is a complex topic, suggest you search the newsgroup:
miscrosoft.public.access.security

hth
 
Top