Forum Discussion
Convert From Accde/Accdr back to Accdb
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...
George - thank you for replying. The original .accdb is available. We have just been recompiling it and releasing back to production. It works for a while but eventually the error pops up.
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.
- The uncompiled .accdb works without problems. The issue is really strange because it occurs only after recompiling and it's been in use for about a week. I've worked with access a very long time and have never encountered this type of behavior. The conversion service has been in touch now so I'll work with them. Thank you all very much for your responses.
- "...it occurs only after recompiling and it's been in use for about a week..."
How about when you use the full accdb for about a week, does it continue to work correctly also?
