Well, I finally broke down and upgraded my primary PC and server to Microsoft Office 64 bit. I've been fighting it, but since that's the default installation now and everyone is getting 64 bit installed, the time has come. So from now on, every sample database that I post will be in 64 bit. 

I have a huge database that I've been slowly building and upgrading and adding-on to since 2002 when I started this business. I was dreading upgrading it, figuring there would be tons of problems. But... alas... nope. I followed my own advice and just added "PtrSafe" to my function and sub declarations. It was relatively painless. Just keep hitting Debug > Compile and Access will take you to the next instance that needs to be fixed. 

There was one minor problem, but it was in a module I don't really even use anymore. It's a set of subs that let you set and get the Windows clipboard, which allows you to copy and paste data outside of Access. That required changing a couple of Long values to LongPtr. Aside from that, nothing else needed to be changed.

So... if a crazy monster database like mine can be upgraded with little effort, ya'll shouldn't have many problems. Post em here if you do.