Microsoft Visual Basic for Applications Compile error: The code in this project must be updated for use on 64-bit systems.

[AngelSpeaks]

I was just going to search for this!

 

[honorkat]

Search for Declare within the whole project.
TBH I cannot see an mdb ever needing to be converted to 64bit as long as you keep using 32 bit Access.

All your colleagues appear to be using 64 bit Access.
Get your company to.make their mind up which they are going to use, and take it from there.

Our company has made up their mind. I just swapped my computer to 32-bit so that someone could maintain it.

 

[honorkat]

goto VBE (ctrl-g) and visit each form, report and Module code.
if you are unable to do it, someone will do it for you just upload your db.

OK, I've been here before. Everything states "Project Locked - Project is unviewable"

 

[gemma-the-husky]

Am I not right in thinking that merely adding ptrsafe does not guarantee that the code actually works correctly in the different environment?

It may depend on what the function actually does.

 

[arnelgp]

maybe it is an .accde created on x32 ms access and you are trying to run it on a x64 ms access, that is a no, no.

 

[honorkat]

In the VBA environment use menu "Debug" -> "Compile ...". Then it should show you the first problematic code right away.

Compile is greyed out. I'm starting to hate this database. lol

 

[honorkat]

maybe it is an .accde created on x32 ms access and you are trying to run it on a x64 ms access, that is a no, no.

it's an accdb

 

[sonic8]

Compile is greyed out.

Are there multiple projects (top level nodes) visible in Project Explorer?
If yes, maybe you selected the project representing an add-in or library database? These are not editable by design.


With hindsight, my suggestion of using Debug->Compile wasn't that good after all. This will work if you open the database in 64bit Access, but in your 32bit Access it will not complain about code incompatible to 64bit.

 

[honorkat]

Are there multiple projects (top level nodes) visible in Project Explorer?
If yes, maybe you selected the project representing an add-in or library database? These are not editable by design.


With hindsight, my suggestion of using Debug->Compile wasn't that good after all. This will work if you open the database in 64bit Access, but in your 32bit Access it will not complain about code incompatible to 64bit.

Since it won't even open on 64bit office computer, then I guess that doesn't do me any good.

goto VBE (ctrl-g) and visit each form, report and Module code.
if you are unable to do it, someone will do it for you just upload your db.

Were you serious on uploading it? As much as I'd like to figure this out, I starting to feel like it's something in the database itself. I could use extra eyes on this at this point.

 

[Gasman]

Save a copy. Compact that. Zip it and upload that zip file.

 

[sonic8]

Since it won't even open on 64bit office computer,

Press and hold the [SHIFT] key and then open the access file. Unless explicitly disabled, this prevents startup code from running and will allow you to open the file.

 

[honorkat]

Save a copy. Compact that. Zip it and upload that zip file.

 

[sonic8]

@honorkat, the file in the Visitors.zip you uploaded is an ACCDE file that was just renamed to ACCDB. The VBA code in file cannot be edited nor viewed.
Find the corresponding ACCDB file and many problems you encountered will resolve themselves.
The code incompatible with 64bit is most likely in the module "GetFileFromAPIModule".

 

[honorkat]

@honorkat, the file in the Visitors.zip you uploaded is an ACCDE file that was just renamed to ACCDB. The VBA code in file cannot be edited nor viewed.
Find the corresponding ACCDB file and many problems you encountered will resolve themselves.
The code incompatible with 64bit is most likely in the module "GetFileFromAPIModule".

well that explains a lot of issues. I still have the mdb file if that helps.

 

[arnelgp]

that was what i was guessing on post #25.

if you want to compile it, compile it both to an x32 MS office and x64 Office.
deliver the x32 to machines with x32 office and the x64 compiled to the machines with x64 office.