Prevent Users from viewing tables in MS Access 2010

Posted on 2012-08-30
Medium Priority
Last Modified: 2012-10-06
We have an outside firm using our MS Access application and we programmatically limit their view of records. I don't want users to be able to view table via the Database navigation dialog.

How can I prevent users from opening up MS Access using the Shift key? The executable accde still allows the shift key. And if I rename the accde to accdr, I get what I need, but any knowlegable user can change it back to accde.
Question by:beehilly
  • 2
  • 2
  • 2
  • +2

Expert Comment

ID: 38350374
This might be what you're after...

LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 38350476
The short answer is that you really can't stop it using Access iteself. While you can disable the shift key bypass as btetlow-expert suggested, a knowlegable user can easily defeat that as well.

 The only way to really protect a DB at this point is to password protect it and use a "launcher" style app which has the password embedded in it and can open the app.  This ensures that it's opened in a specific way (ie. runtime mode).

  If the user tries to open the DB without using the launcher, they don't know the password and can't open it.

LVL 77

Assisted Solution

peter57r earned 1000 total points
ID: 38350478
I'm afraid that a 'knowledgable user' can now bypass any security you try to apply to tables.

The shift-bypass key can be enabled/disabled from an external program (another Access database for example) so what you are asking about is not foolproof.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 38351339
Thanks for all your responses
LVL 85
ID: 38353663
And one thing to remember is tha tin most cases, the data belongs to the end consumer, not "the application". In other words, you really can't disallow your end user the ability to get to the data, whether that be directly through tables, or through an export utility that you provide.

The exceptions would be where you provide them with the data, and they use your program to build scenarios, or to lookup items - for example, an auto parts store that provides their commercial customers with a database of all their inventory.

Author Comment

ID: 38464047
I've requested that this question be deleted for the following reason:

Doesn't seem to be answerable.
LVL 77

Expert Comment

ID: 38464048
I think the answer was quite clear.  What you are asking can't be done.
LVL 85
ID: 38465082
Agreed. These two should be the answers:


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question