If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
password protection
I want to protect a table so that noone can delete a record? Is it possible
to just put a password protection on a data table if someone tries to delete a record they have to enter a password? |
#2
|
|||
|
|||
password protection
Not that I'm aware of.
If you are using this table as the RecordSource for a form, you will also have to prevent deletion of a record via that form. I think you could use the forms BeforeDelConfirm event to popup your own dialog box and prevent allow or prevent the action based on a password. But this will not work if they just open the table directly. Something else you might consider is hiding the table, then only someone that knows what they are doing, and actually knows the table exists could get to the table. - To do this in 2003 and earlier, right click on the table name, then select properties, then check the Hidden attribute. Then in the Access Tools menu, select Options, then, on the View tab, uncheck the Hidden Objects. - Another way to accomplish this is to append "uSys" to the front of the table name, which makes it a user system table. You will need to make sure that the System Objects checkbox on the View tab is unchecked to make this work. You will also have to change the name of the table everywhere else in the database where it is used. This can be a time consuming, and error prone, process. HTH Dale "Belinda7237" wrote in message news I want to protect a table so that noone can delete a record? Is it possible to just put a password protection on a data table if someone tries to delete a record they have to enter a password? |
Thread Tools | |
Display Modes | |
|
|