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...
hi, Did you try decompiling the accdb before compiling and generating the accde ?
- I normally just recompile the accdb. I can perform the decompile if and when the error pops up again.
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- Yes, I understand only the accdb for decompile. I will probably add the decompile step to our production migration process. Thank you.
