Password Encrypting Database Table

[data808]

is Access not like Excel where I can just put a password on the database table to prevent people from editing it? Excel is very simple to do this. however, it seems that Access you will have to do VBA scripting to get this task done. Is this true?

[help_me_with_access]

??? how do you do it in xl?

[data808]

in excel you just go to the review tab and look under the protection category. there you can set permissions to the sheet, workbook, etc...

this is what i would like to do with Access for my database table. i have a couple forms and one database table. i would just let to set permissions to the database table so that only the administrator can edit this database. but it seems that everywhere i ask on how to do this in Access, everyone keeps saying that I need to do a VBA script of some sort.

[help_me_with_access]

access doesn't have this ability because you're not supposed to have access to tables. permissions on objects? I don't think you can do such a thing. unless the user level security wizard allows such a thing. but I think that's only per the database file and not individual objects.

so if that's true, yes you'd need code. but if that's still a requirement of yours, you're not using access for its intended purpose. might want to look at that issue first.

[data808]

you may be right about that. let me explain the scenario in which I'm using Access to begin with.

i have two forms which is used to enter data into by a clerk. these two forms also share one database table in which the data entered is saved as a record.
when the clerk enters data into one of these forms, before closing the form so that it saves to the database table, they will have to print this form to give to the customer. almost like a receipt.
once the form is printed they can close the form and the record will be saved to the database table.
now if the clerk wanted to, they could go straight to the database table and delete the record or edit the records. this is what I'm trying to prevent.
is there a way to stop this from happening? or is there a better scenario to do something like this in your opinion because technically, the clerk could also delete all the fields in the form of all the data they entered and the record would never be saved in the first place.
do you or anyone have any suggestions?

I'm new to access and I am learning as I go. Thanks.