Form not longer works when database is transferred from Access 2019 to 2013

[N1234]

Hello!

I transferred my database from a PC with Access 2019 MSO (32 bit) to my other PC that has Access 2013 (64bit) and the form's search functions (keyword search and dropdowns) no longer work. Anyone else experience this before and is there a way to remedy this issue?

Thanks again,

Nikki

 

[theDBguy]

Hi. What error messages were you getting?

 

[N1234]

Hi. What error messages were you getting?

Hello again!

I wasn't getting any error messages but the dropdowns and the keyword searches return nothing in Access 2013 32bit.

 

[theDBguy]

Hello again!

I wasn't getting any error messages but the dropdowns and the keyword searches return nothing in Access 2013 32bit.

Did you try stepping through the code then? I just tried your file using 2016, and it's working fine.

 

[N1234]

Did you try stepping through the code then? I just tried your file using 2016, and it's working fine.

I went through the code but I'm not getting any errors.

 

[The_Doc_Man]

Going from 32-bit to 64-bit and getting errors probably means you should at least decompile and recompile your code.

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

www.fmsinc.com

This might not be enough, because some of the 32-bit run-time libraries don't work for 64-bit Access. But the decompile/recompile is probably the easiest first shot at a quick fix.

 

[N1234]

Going from 32-bit to 64-bit and getting errors probably means you should at least decompile and recompile your code.

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

www.fmsinc.com

This might not be enough, because some of the 32-bit run-time libraries don't work for 64-bit Access. But the decompile/recompile is probably the easiest first shot at a quick fix.

I just decompiled (run command line) and compiled again using the debugger. I still get no errors but the form is still non-functioning.

 

[theDBguy]

I just decompiled (run command line) and compiled again using the debugger. I still get no errors but the form is still non-functioning.

Hi. When you said you "went through" the code, did you actually "step through" them? I mean, did you verify the code is actually firing/executing?

 

[N1234]

Hi. When you said you "went through" the code, did you actually "step through" them? I mean, did you verify the code is actually firing/executing?

I tried running step into but I get nothing. I really don't know what's going on here, the code works fine in 2019 and 2016 but in 2013 32 bit the form is nonfunctional.

 

[theDBguy]

I tried running step into but I get nothing.

Does that mean the code is not running at all? That's what it sounds like you're saying. Is the db stored in a Trusted Location?

 

[N1234]

Does that mean the code is not running at all? That's what it sounds like you're saying. Is the db stored in a Trusted Location?

DB is stored in a trusted location, it does seem like an issue with code execution. I just had someone with 2013 32 bit run the db and it worked flawlessly. Can someone run the db on a 64 bit access?

 

[theDBguy]

DB is stored in a trusted location, it does seem like an issue with code execution. I just had someone with 2013 32 bit run the db and it worked flawlessly. Can someone run the db on a 64 bit access?

Sorry, I don't have that. Hopefully, someone else will jump in and help us further. Good luck!

 

[N1234]

Sorry, I don't have that. Hopefully, someone else will jump in and help us further. Good luck!

Ty. I appreciate your help!

 

[theDBguy]

Ty. I appreciate your help!

Quick question though. Are you saying the 2013 machine is using 64-bit Access?

 

[N1234]

Quick question though. Are you saying the 2013 machine is using 64-bit Access?

Yes one of the machines is using Access 2013 64 bit.

 

[isladogs]

Do you have Require Variable Declaration ticked in Access Options? If not, tick it.
Xo you have Option Explicit in the declarations section of each code module? If not add it after Option Compare Database.
And does the code compile in 64-bit A2013?