Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11

    Shift Bypass key program not working


    here is the shift bypass key program that i got off this site years ago. i also have another one that some one created for me as well. nether work now. can someone help. i believe its 32 vs 64 bit issues
    Attached Files Attached Files

  2. #2
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    any help would be greatly appreciative. i really dont know VBA code. so im kind of at a loss here

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    As you appear to have obtained it from Utter Access, would it not be prudent to ask there?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    phil; I'll take a look. It doesn't matter to me where you got code from if you're here for help. The only thing I don't care for when it comes to other forums is when people cross post in other forums for the same issue and don't provide the link as per the rules.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    you are prob right, been a while since ive been on these sites. have not had any issues.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Quote Originally Posted by Micron View Post
    phil; I'll take a look. It doesn't matter to me where you got code from if you're here for help. The only thing I don't care for when it comes to other forums is when people cross post in other forums for the same issue and don't provide the link as per the rules.
    It does not matter to me much either, but my first point of call would be to go to the horse's mouth so to speak.

    I do not have a 64 bit setup. TBH I was not even aware a mdb could be set to 64bit?
    Plus I do not have experience of amending for 64 bit, so suggesting they ask at source was all I could offer.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    i have not posted in any other sites. forgot there was that other site. and thank you for taking a look. it seems that there are a lot of topics on this issue with the 365 updates. but im not a code writer so i really dont know what im doing.

  8. #8
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    un furtunatly i now have a few DB's that are shift key locked and i cant get into the back end anymore. because of this issue

  9. #9
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Well if you go looking on that site, isladogs has alternative code that works in either bitness?

    https://www.utteraccess.com/topics/233728

    Why would the bypass stop you getting into the BE?

    Edit: In fact Colin has changed his site since he posted in that thread.
    Look on his site at https://isladogs.co.uk/improve-security-2/index.html
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  10. #10
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This type of code is common and has nothing to do with 32 vs 64 bit.
    So "not working" means what? db's whose bypass property has been set to not allow cannot be opened? That should have nothing to do with this code either as it (usually) doesn't prevent opening other db's. It just prevents bypassing when doing so. If you can't open, I would say you have a different issue.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Here is an updated link to the article I mentioned in that UA thread
    Improve Access Security 2 (isladogs.co.uk)
    The article includes an example app to disable or enable the shift bypass and, as already mentioned, it works in both bitnesses.

    It is ALWAYS possible to remove any protection added by disabling the shift bypass. It can also be done externally from another database
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    ok i may have said that 32 vs 64 in error. it did come up in the error code. the program was used to disable the Shift Key bypass, but now the program does not run. and all my DB's are locked from getting in to the back end. because the shift bypass key is disabled. i need the program to run so that i can enable the shift bypass key for each DB. if that makes it any clearer

  13. #13
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Seems that program you attached was written by R Hicks and he also supplied a 2kTo2k10 version which at first glance looks the same.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  14. #14
    phil12586 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2022
    Posts
    11
    Click image for larger version. 

Name:	Screenshot 2022-10-20 124121.png 
Views:	29 
Size:	123.8 KB 
ID:	48932 here is a screen shot of the error code

  15. #15
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That code in post 14 has nothing to do with shift bypass. I'll let others familiar with that code take over.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Bypass (Shift) key not disabled
    By skydivetom in forum Forms
    Replies: 6
    Last Post: 07-13-2019, 08:16 AM
  2. Shift key doesn't bypass ODBC connection
    By Glenn_Suggs in forum Import/Export Data
    Replies: 4
    Last Post: 01-06-2019, 09:48 AM
  3. Enabling shift bypass
    By reynier09 in forum Access
    Replies: 4
    Last Post: 08-18-2016, 08:25 PM
  4. Secuuring the SHIFT bypass function
    By awhittle23 in forum Security
    Replies: 1
    Last Post: 06-22-2016, 06:09 PM
  5. Replies: 3
    Last Post: 06-22-2016, 04:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums