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.

John_Vallier 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.

if for any extension change and the db code is still unviewable, then it is an .accde.changing the extension does not change the fact that it is already compiled as accde.access will see this by reading the file signature.

Hi George, Actually there is 1 way: Wayne's conversion service It's commercial, but the only one and excellent. ServusKarl****************Access Bug TrackersAccess NewsAccess DevCon

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.

Thank you arnel_gp for replying.

Convert From Accde/Accdr back to Accdb | Microsoft Community Hub

George_Hepworth
Silver Contributor
Feb 02, 2023
John_Vallier
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.
- Karl_Donaubauer
  MVP
  Feb 02, 2023
  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
- John_Vallier
  Copper Contributor
  Feb 02, 2023
  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.
  - George_Hepworth
    Silver Contributor
    Feb 02, 2023
    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.
arnel_gp
Steel Contributor
Feb 02, 2023
if for any extension change and the db code is still unviewable, then it is an .accde.
changing the extension does not change the fact that it is already compiled as accde.
access will see this by reading the file signature.
- John_Vallier
  Copper Contributor
  Feb 02, 2023
  Thank you arnel_gp for replying.
loufab
Copper Contributor
Feb 06, 2023
hi, Did you try decompiling the accdb before compiling and generating the accde ?
- John_Vallier
  Copper Contributor
  Feb 06, 2023
  I normally just recompile the accdb. I can perform the decompile if and when the error pops up again.
  - loufab
    Copper Contributor
    Feb 06, 2023
    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

Forum Discussion

Convert From Accde/Accdr back to Accdb