Feb 01 2023 12:36 PM
We have a need to convert a database from .accde/.accdr back to .accdb. Weekly now, from 12/24/2022 to present, the error 3464 Datatype mismatch in criteria expression pops up. After recompiling the database, it works for a while, about a week later, the error resurfaces. We have narrowed down the place where the error occurs, it is one form. We have altered the extension from .accdr to .accdb but that does nothing for code access/view as the VBA objects remain in an unviewable state.
I appreciate any insight you may have.
Feb 01 2023 04:05 PM
Unfortunately, there is no way to convert an accde to an accdb. That's actually one of the reasons for creating an accde: changes to VBA and other objects are blocked.
Somewhere in your environment, you should have the original accdb from which the accde was created. You can use it to correct the error and then recreate a new accde to replace this one with the flaw in it.
Feb 01 2023 04:51 PM
Feb 01 2023 05:47 PM
Hi George,
Actually there is 1 way: Wayne's conversion service
It's commercial, but the only one and excellent.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
Feb 02 2023 06:55 AM
Feb 02 2023 07:24 AM - edited Feb 02 2023 07:37 AM
Ah, the original description implied that you didn't have the accdb. So, the problem is in that accdb itself. That's where you have to find and correct the problem BEFORE recompiling to accde again.
It is possibly an unhandled error in the VBA, OR incipient corruption in the source accdb.
Karl's right about the conversion service, and I would have suggested that if you didn't have the acdb to work with.
Feb 02 2023 11:29 AM
Feb 02 2023 05:39 PM
Feb 06 2023 12:26 PM
Feb 06 2023 12:35 PM
Feb 06 2023 12:43 PM - edited Feb 06 2023 12:45 PM
No, the decompilation only works with an accdb.
It recreates many important things in an accdb. I do it before each delivery in production.
This may fix your problem.
Use this procedure on my blog :
http://blogaccess.free.fr/?p=75
Feb 06 2023 12:56 PM