Stop Shift key functionality...

  • Thread starter Thread starter NWO
  • Start date Start date
N

NWO

Hello.

First, I have read the posts for suggestions on how to disable the shift key
so when I deploy an Acces Application (with no code) to a shared Drive, a
user can't hold down the Shift key to get to the Tables, queries, etc. The
problem I have, however, is how to enable the shift key with some type of
password (or something) so I can get into the tables and queries to make
modifications. Please don't direct me to a site. I'm just looking for some
basic code to accomplsih the above. Any suggestions woudl be appreciated.
I'm not a programmmer, but I know how to get the code in a module, save, etc.

Thank you in advance.

NWO :)
 
You can do it, but I would not advise it.
The better approach would be to keep your "master copy" where only you have
asccess to it. The lock down the copies you distribute to your users. I
would also recommend you only distribute mde or accde versions to users.
 
Love it! That's why they pay you folks the big bukcs :)

Now, can you please advise of the basic code to lock the shift key in a
secure manner so somebody can't just go to Google and circmvent the system!
I can't download files to my work computer, but I can copy a code snippet.

Thank you again for the simplistic solution to my problem Klatuu.

NWO :)
 
Hi Ken.

Thnaks for the link.

Now I know you folks dont get paid for the solutions and advise that you
send - I was just suggesting a little humor.

Take care.

NWO
 
NWO,

Just considere this:

If you take Dave's advise and only distribute an mde or accde type access
file to your users, you will not have to worry about them "just go to Google
and circmvent the system" because they will not be able to get to any thing.
With these type of files, no one had the ability to use the shift key when
opening the file, not even you.

Again, Dave has provided the correct approach.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
Thnak you.

I just discovered that even when saving the MDB as an MDE, Iuser can still
hold down the Shift Key. DO I still need to apply the code even wioth an MDE
file?
 
Back
Top