VBA code missing in ACCDE - Access 2016

[pawjer]

Hi,

I know this issue has been widely explained all over the Internet but despite all suggested steps, when saving file in ACCDE format, my destination file misses VBA code and modules.

Steps I have already made:

1. The directory in which both accdb and accde files reside is added to trusted directory.


2. I have tried to compile DB with Debug->Compile option before converting to ACCDE but it seems it is already done as this option is greyed-out.
3. I have used another machine with Access 2016 and I get exactly the same result.

Has anybody any idea where I should also look for a solution? I hope it is so simple I cannot figure it out

I will be very grateful for suggestions and ideas.

Kind regards,

Pawel

[aytee111]

The definition of accde is without code.

[Micron]

To be more precise, the code exists as compiled machine language/code and is no longer accessible. If you're saying you lost functionality (something no longer works) that is is a different matter.

[pawjer]

Sorry for being not enough precise.

I do not expect ACCDE file to contain editable modules or vba code but I need the same DB functionality as it is in original ACCDB file. In my ACCDE file, everything that was written in VBA is not present in terms of functionality.

Hope it explains my problem.

Paweł

[CJ_London]

is the accde in a trusted location? have you allowed macros to run?

[Micron]

Any error messages? Did you also switch to 64 bit OS?
What happens to let you know you're missing functionality?

[pawjer]

is the accde in a trusted location? have you allowed macros to run?

Yes it is. Doesn't help unfortunately.

[pawjer]

Any error messages? Did you also switch to 64 bit OS?
What happens to let you know you're missing functionality?

No error messages. It is 64 bit OS, i.e. Windows 10.

The problem is that vb code put in accdb does not work after exporting to accde.

[Micron]

Does code contain external library calls (e.g. API calls) and if so, we're they adapted for 64 bit? Research ptr safe for examples and how to code for this.

[CJ_London]

if you open the accde, can you see the forms, reports and modules in the navigation window? If so, what happens when you open the main navigation form?