Create AllowByPassKey Property in ACCESS 2003

I have procedures that work nicely in several databases that disable the AllowByPassKEy property.  But every now and then I get an error when I put it in a new database that the AllowByPassKeyproerty does not exist.  I know that it can be created, and I have done this, but I cannot find the code.  So, how do I actually first create the property in VBA in ACCESS 2003?

Sandra
Sandra SmithRetiredAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The link below contains an MDB which allows you to 'set' and 'reset' the Shift Key Bypass from a REMOTE mdb.  
It's very cool. Scroll down the page to 'By Pass Shift Key Code'
And it works in A2010 also.
http://www.kallal.ca/msaccess/msaccess.html

mx
0
 
Sandra SmithRetiredAuthor Commented:
Thank you!  I have databases covering 2003, 2007 and 2010 so anything I can port across simply makes things easier.

Sandra
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
It's a cool little utility ... thanks to Albert.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.