Locking a table 11/06

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Please step down into 'Lamens World' for this one.
I want to lock a certain table in my database.
I am using this table as an archive for 'out of date'
information. I don't want anyone, even the owner of the
db, to be able to do anything but add new information,
search and view the records in this table. How can I do
this be done?

Thanks.
 
Please step down into 'Lamens World' for this one.
:-?


I want to lock a certain table in my database.
I am using this table as an archive for 'out of date'
information. I don't want anyone, even the owner of the
db, to be able to do anything but add new information,
search and view the records in this table. How can I do
this be done?
Click to expand...

Sure. Many people believe that the owner of the database, has (or can
acquire) full permissions to every non-system object in the database. But
that is simply not correct. So there is nothing wrong, in principle, with
what you are after.

I don't have Access here to check, but this should do it. Ensure that the
table in question is owned by a user who *is not* defined in the workgroup
file that the database is normally run against. (So for example, create MDW
#1; create user Tom; log in as Tom; create new table in the database; assign
permissions (see below); then log out, put MDW #1 away, & revert to using
your normal MDW, MDW #2.)

At the "assign permissions" stage, have Tom assign Add permission to the
Users group, but no other permissions of any kind to any other user or
group.

As I say, I don't have Access here to check, and this is a tough one to get
right, without being able to check. So let's hope I have not bob-boo'd the
details!

HTH,
TC
 
Back
Top