INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

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.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...It is good to know that there are groups such as this willing to share knowledge in this money driven economy..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Tables and Relationships Forum

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

Read More Threads Like This One

Pack10 (Programmer)

25 Jan 12 17:02

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

dhookom (Programmer)

25 Jan 12 21:57

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

MazeWorX (IS/IT--Management)

27 Jan 12 4:49

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>>

lameid (Programmer)

3 Feb 12 9:15

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).

Pack10 (Programmer)

3 Feb 12 12:19

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

Thanks all.

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!

Back To Forum

Back To Microsoft: Access Tables and Relationships