Creating ACCDE Error (MakeMDEFile isn't available now)

[CodLiverOil]

Hello and help!

I'm stuck with this one and it's driving me nuts.

I have my database all working fine, front and and backend perfect (ish) so I wan't to create an ACCDE to roll out. While I was building the DB I created several ACCDE copies for testing and they all worked fine, but now when I try I get the generic error "The command or action 'MakeMDEFile' isn't available now"

I am using Access 2010 32bit v 14.0.7153.5000 on a Windows 10 x64 computer.

I have checked or tried the following based on info from MS and from searching the problem on the 'net;

Checked that the path to the accdb file is in the 'Trusted Path' list (Options > Trust Centre > Trust Centre Settings > Trusted Locations).


Copied all the forms, code, queries etc into a new database file.
Complied the VBA code before trying to save as ACCDE (complied OK - no problems reported).
Run Access as Administrator.
Checked permissions on the C:\Program Files (x86)\Microsoft\Office 2010\Office14\ACCWIZ folder.
Done a SETUP > REPAIR of Office

And still no joy.

I can convert a more basic database fine so I know it's not the computer/conversion process - it must be something in the database that's causing it. So anyone have any more suggestions on what could be the cause, or any alternative ways of compiling a ACCDB frontend into a secure, distributable file?

Many thanks.

[CodLiverOil]

Well, butter my bananas and call me Charlie... after 2 days of trying to figure this out I post on here then quite by accident find the issue - so for the rest of you who have the same stupid generic MakeMDEFile Isn't Available Now error, I hope this might be of help to you....

If you have gone into OPTIONS > CURRENT DATABASE > and un-ticked the DISPLAY NAVIGATION PANE option, that is was was causing my problem?!?!?!?! f'ing stupid thing.

You can set all the elements in the navigation pane to hidden so it shows just a blank pane, but if you turn the pane off - the error comes back.

Hope that helps someone else.

[tanvi]

Follow these steps:
· Start Microsoft Access.
· On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002-2003 File Format.
· In the Database to Convert From dialog box, select your database or the project file, and then click Convert.
· In the Convert Database Into dialog box, specify the name of the new Access 2003 database, select the location where you want to store the new file, and then click Save.
· To complete the conversion, click OK.
· Open the database or the project file that is created in step 4.

Notice that the Make MDE File (or Make ADE File) command is now on the Database Utilities option of the Tools menu.

[KCMHProgrammer]

Well, butter my bananas and call me Charlie... after 2 days of trying to figure this out I post on here then quite by accident find the issue - so for the rest of you who have the same stupid generic MakeMDEFile Isn't Available Now error, I hope this might be of help to you....

If you have gone into OPTIONS > CURRENT DATABASE > and un-ticked the DISPLAY NAVIGATION PANE option, that is was was causing my problem?!?!?!?! f'ing stupid thing.

You can set all the elements in the navigation pane to hidden so it shows just a blank pane, but if you turn the pane off - the error comes back.

Hope that helps someone else.

Finally! This is what I was looking for.

Thanks Charlie :-)