Solved Securing Access databases using Active Directory (64-bit)

[foshizzle]

We've recently started rolling out the 64-bit version of all Microsoft Office applications. The problem is, this broke the security which was originally from accesssecurityblog.com and no longer online. Luckily, I did a copy/paste for my documentation which is shown on the attached PDF.

I've found a post from Stack Overflow where someone had tried updating the code to 64-bit.
I believe I've managed to piece everything together but now I am receiving an error "Subscript out of range" when I try to open _frmNavigation
All code compiles with no errors.

I'm attaching a demo of my database below, hoping someone could point me in the right direction.
Thank you all!

 

[isladogs]

Now crossposted at https://www.utteraccess.com/topics/2064514

The fact that the code compiles in 64-bit doesn't mean it will work.
You need to check all the API declarations with a suitable tool like:
Windows API Viewer for MS Excel (rondebruin.nl)
Access 32to64 Bit (thememydatabase.co.uk)

 

[sonic8]

I believe I've managed to piece everything together but now I am receiving an error "Subscript out of range" when I try to open _frmNavigation

You code contains this comment multiple times:

'Protection if programmer forgot to call CacheSecurityGroups from startup code.

It appears the programmer has not only forgotten to call the mentioned method, but also disabled the "protection" against this mistake.

 

[arnelgp]

try and test.

 

[foshizzle]

try and test.

arnelgp - Thank you.

I no longer get the error when opening the form and have verified the security works as its supposed to!