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
