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
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
any help would be greatly appreciative. i really dont know VBA code. so im kind of at a loss here
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
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.
you are prob right, been a while since ive been on these sites. have not had any issues.
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
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.
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
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
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.
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
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
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
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.