Unable to Create the accde file

[John Lee]

Good day, Folks,

I have been trying to create the accde file for my database and I have been following the on screen instructions, however I keep getting the message "Microsoft Access was unable to create the .accde, .mde, or .ade file"

I have check through were there is code written and "Option Explicit" is entered just underneath the "Option Compare Database" and no compile error messages or variables not declared message are coming up! Does anyone have any ideas of what it is that I may be missing in this process.

Your assistance is most appreciated.

 

[arnelgp]

close your db.
start Access, then Open the database (Browse).
next Open it Exclusively.
then make .accde.

 

[John Lee]

close your db.
start Access, then Open the database (Browse).
next Open it Exclusively.
then make .accde.
View attachment 118453

Hi arnelgp, Thanks, I'll give that a go, cheers

 

[John Lee]

close your db.
start Access, then Open the database (Browse).
next Open it Exclusively.
then make .accde.
View attachment 118453

Hi,

I tried your suggestion, but I kept on getting the same message, so a bit stumped at the moment, I'll go back and check through the database again to see if I can identify anything that may be upsetting the cart.

 

[Gasman]

Is it split?
Upload the DB and see if someone else can make an accde?

 

[arnelgp]

did you try same thing as in the video?

 

[Josef P.]

Possibly run /decompile first and then compile again. Perhaps a compile error will then be displayed.

 

[gemma-the-husky]

I would open a code window, and try to compile the project again. It's hard to see why you can't create a .de file unless there is a compile error. You don't need to have option explicit in order to compile - that just forces you to declare any variables before you can use them..

 

[AngelSpeaks]

The only time I ran into this is when my database had too much bloat. Recreate it by copying all objects into a new db.

 

[arnelgp]

is john lee same person as john papa?

Unable to create .accde

I have a .accdb which is 92Mb and lately it is difficult to create a .accde. It is telling me that the .accdb is still in use. Does this have to do with the TableIDs that are created during the .accde creation process? Any ideas?

www.access-programmers.co.uk

 

[AHeyne]

@John Lee : Do you reference an accdb file in your accdb to be saved as accde? This would also prevent it.

 

[isladogs]

In addition to the many excellent points already mentioned, other factors can also prevent creation of ACCDE files.
For example, if you have any empty procedures.
See my article for more suggestions:

Why can't I create an ACCDE file?

This article explains the main reasons why creating an ACCDE file may fail. It also explains how to fix those issues

www.isladogs.co.uk