Forum Discussion

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Feb 01, 2023

Re: Convert From Accde/Accdr back to Accdb

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. 

 

 

5 Replies

  • John_Vallier's avatar
    John_Vallier
    Copper Contributor
    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's avatar
      George_Hepworth
      Silver Contributor

      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.

      • John_Vallier's avatar
        John_Vallier
        Copper Contributor
        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.