Access Error

Highlighted
Occasional Visitor

I am receiving this error when I try to use access:

The expression On Open you entered as the event property setting produced the following error:

The code in this project must be updated on 64 bit systems. Please review and update Declare statements and the mark them with the PtrSafe attribute.

1 Reply
Highlighted

@Ramonmonchis2411 

 

The accdb you are trying to use was created with 32 bit MS Access.

 

You are running 64 bit MS Access. It used to be that MS Office installed the 32 bit version by default, but beginning with the most recent releases, the default is now 64 bit and you have to work to change that if you want to do otherwise. Up until very recently, most Access developers do suggest you uninstall the 64 bit version and instead install that 32 bit version. I'm not so sure it's that good an idea for many situations, but it's worth considering.

 

If you installed 64 bit Office by choice, then you'll need to modify the VBA in your Access-based relational database applications accordingly. See this blog post for background.