I have had to do this.  The easiest way is to open the 32 bit database in the 64 bit Access environment.  Then go into a code window and compile the code.  It will start bowing up where you have not put the ptrsafe code, which is typically on functions.  Once you compile with no errors, then you are most likely done fixing the broken code.  It will then work in both 32 bit and 64 bit, but it might depend on what the code is doing as every database is different...

Unfortunately, no, there is no "automatic" way. I do what John recommends.

See also: 64-Bit Access

Another option: if you can't figure out how to get a particular function 64-bit ready, give it to ChatGPT. It's really good at this kind of thing.

Thank you all for your help.  I used a combination of John Campbell and my own search for "Declare".  So far it has worked.  Great work from a great team