asked on

Prevent Users from viewing tables in MS Access 2010

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.

btetlow-expert

This might be what you're after...

http://www.databasedev.co.uk/disable_shift_bypass.html

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

beehilly

ASKER

Thanks for all your responses

Scott McDaniel (EE MVE )

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.

beehilly

ASKER

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

Doesn't seem to be answerable.

peter57r

I think the answer was quite clear. What you are asking can't be done.

Scott McDaniel (EE MVE )

Agreed. These two should be the answers:

http:#a38350476
http:#a38350478