Database Security

[Guest]

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?

 

[Joseph Meehan]

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?

Make it a mde file.


If your database contains Microsoft Visual Basic for Applications (VBA)
code, saving your Microsoft Access database as an MDE file compiles all
modules, removes all editable source code, and compacts the destination
database. Your Visual Basic code will continue to run, but it cannot be
viewed or edited. Saving your database as an MDE file secures you forms and
reports without requiring users to log on or requiring you to create and
manage the user accounts and permissions that are needed for user-level
security.

Your database will continue to function normally--you can still update data
and run reports. Additionally, the size of the database will be reduced due
to the removal of the code, so memory usage is optimized, which will improve
performance.

Saving your Access database as an MDE file prevents the following actions:
Viewing, modifying, or creating forms, reports, or modules in Design view.
Adding, deleting, or changing references to object libraries or databases.
Changing code - an MDE file contains no source code.

Importing or exporting forms, reports, or modules. However, tables, queries,
data access pages, and macros can be imported from or exported to non-MDE
databases.

 

[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