32 bit to 64

Question

I am running a 64 bit copy of Access Window 10 and cannot run one of the sample databases from Access 97.   When the application is opened, there is an error message "The code in this project must be updated for 64 bit systems, please review and update Declare statements and mark them Ptrsafe" , how can I open my 97 Address Book sample files I have made using window 10.  Thank you.

Answer 1

Hi,

If you can't open the database while holding down the Shift key, then you may have to find a computer or someone with an older version of Access (at least 2010, I think) to open it for you.

Just a thought...

Answer 2

Hi,

I'm afraid Access 64-bit does not have the same feature that is in 32-bit Access.

Please refer to tne follosing article.

What's the difference between Office 365 and Office 2016? - Office 365

Regards,

---

Ashidacchi -- http://hokusosha.com/

Answer 3

What version of Access do you have installed?

The OS, or Windows 10, had no bearing on this issue.  It is the version and bitness of Access that is important.

Access 2016 cannot open Access 97 files directly, see http://www.devhut.net/2017/05/16/access-database-file-compatibility-table/.  So you need to use an intermediary version of Access to convert the file to a newer format and then you should be able to open it.  Then, once that is sorted out, you might still have the 64 bit issue if that is indeed what you are running.

Why not use one of the sample from your version of Access so you don't have to deal with these issues?

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 4

Hello Rockgrannay,

I'm wondering if your access database file has a macro used Declare statements. Declare statements for 32bit and 64bits office are different.

Please try to refer to below link to check if it is related to Declare statements and resolved it if it is.

"Compile error: The code in this project must be updated for use on 64-bit systems" error message when you edit a VBA macro in the 64-bit version of an Office 2010 program

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 5

You need to fix the Windows API declare statements so that they support 64-bit. See the below link for more info:

http://blog.nkadesign.com/2013/vba-for-32-and-64-bit-systems/

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 6

Hello ,

Has your original issue been resolved? If it has, I would suggest you mark the helpful reply as answer or provide your solution and mark as answer to close this thread. If not, please feel free to let us know your current issue.

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].