INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Can a table be locked out to users from the Navigation Pane.

Can a table be locked out to users from the Navigation Pane.

(OP)
I have been charged with researching an issue.
We have a table that acts as an audit log.
Is there a way to lock that table to unauthorized users or access.
By that I mean, we need the system to log the transaction but we dont want the table to be edited if someone opens up the database with a shift-enter to get to the Navigation pane. Is this possible.

Thx

RE: Can a table be locked out to users from the Navigation Pane.

There are ways to make this difficult but probably not impossible. You could try hiding the table or beginning its name with "usys". You could also use code to push audit records to a table in another database file.

Duane
Hook'D on Access
MS Access MVP

RE: Can a table be locked out to users from the Navigation Pane.

You should lock the db down by disabling the AllowShiftBypassKey option as well as other start up options which can easily be accomplished with code. As Duane has suggested you need to make the table a hidden object of the db other wise someone can still link to it and finally you should make the db an MDE file to complete the process

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

RE: Can a table be locked out to users from the Navigation Pane.

The best option would really be to move to a full RDBMS package like SQL Server where security is both strong and easily managed.  Access security is comparatively week and ultimately not native in newer versions but supported for legacy formats.

If you have a Access 2003 or earlier you can use Access security to remove update and delete permission....  You could even use a separate file for the log table but still use a more current accdb file for your other data (Not sure what kind of performance hit you will take).

RE: Can a table be locked out to users from the Navigation Pane.

(OP)
For us, hiding the table will work and disabling the F11 key does the job for me at this time.

Thanks all.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close