I have an app in Access 64 bit, and I need to have people use it on 32 bit computers. How can I do that?
How do I convert Access 2010 64 to be used on 32 bit systems?
Collapse
X
-
You can not.
Once the application is created or converted to a 64bit formated file it can not be used on a 32 bit system
There is a very recent thread covering this topic:
Running a 32 bit database on a 64 bit machine -
in your code in the 64-bit version, make a copy and do the following on the copied file
remove PtrSafe
save the project
you won't be able to run it on the 64-bit platform or even close the application so you will need to end task the ms-access from Task Manager
open the copied file in the 32-bit platform and you're good to go
hopefully this works for as it did with me.Comment
-
An accdb file is not by itself bit-specific, only if you have coded API calls specifically for 32 or 64 bit, which you normally wouldn't do.
"Removing PtrSafe" makes only sense if you run Access 2007.
Thus, an accdb file (or renamed to accdr) as is will run in 32-bit Office as well as in 64-bit Office.
However, if you compile the file to an accde file, this must be done using the same bitnes of Access as that installed at the intended users.
Thus, if you have both users running 32-bit Access and users running 64-bit Access, you must create both a 32-bit and a 64-bit accde file.Comment
-
You could try creating a brand new Access 2010 application on a 32 bit machine. Then copy the objects out of the 64 bit application to the 32 bit application. You may have some modifications to make in your code as there may be some code/features that 2010 application can not include from the newer application. But it should be a short rework. I have never done this, but this would be my approach to the problem. Good luck.Comment
Comment