Stop Shift key functionality...

[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

 

[Klatuu]

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.

 

[NWO]

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

 

[Ken Snell MVP]

See http://www.mvps.org/access/general/gen0040.htm

One word of advice, if I may -- all advice is helpful and may be useful at
some point, even if it's not what you believe you need right now.

Oh, and our big bucks are 0 dollars always. Have a good day.

 

[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

 

[Mr. B]

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

 

[NWO]

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?

 

[Mr. B]

NWO,

I stand corrected. I was simply mistaken. Learned something today, just
like everyother day.

I would say, yes, you need to apply the the code if you want to restrict
users from using the shift key.

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