[AccessD] How To Undo Disabled Shift Bypass

"The normal way to fix this is to open a new Access file and import all
the objects, then reset references, startup properties, and options."

Not for everyone.  :-)

I think you will find that quite a few of us have a similar module in little MDB that we keep in 
our toolboxes.  Still, it's good to remind people occassionally


-- 
Stuart

On 24 Feb 2011 at 7:40, Dan Waters wrote:

> Sure been quiet for a few days!  So this is something I finished
> yesterday.
> 
> A few days ago, for about the hundredth time, I accidentally locked
> myself out of an Access file by mistakenly running code to change its
> properties, including setting the AllowShiftBypass property to False. 
> The normal way to fix this is to open a new Access file and import all
> the objects, then reset references, startup properties, and options. 
> It´s a pain.
> 
> I recently did some work with OpenCurrentDatabase, and wondered if I
> could make a utility to reset an Access file´s properties where that
> file had its properties set to False.  And it worked!
> 
> Below is code that you can copy into a standard module in a new Access
> file.  Name that new file AllowBypass.mdb, or something similar.  Run
> the first procedure - this will ask you to select an Access file, and
> it will then reset several properties to true so that you can open it
> normally again.  
> 
> Hope someone can use this!
> Dan
>