Topics Search

.MDE file Microsoft Access was unable to create an MDE database

.MDE file Microsoft Access was unable to create an MDE database
Views: 3
I had created an .mde file for my new dbase then distributed it. After I made several changes,mde.correct?

When I went to Tools, Database Utilities, Make MDE File, I get the message: Microsoft Access was unable to create an MDE database.

When I open the VBA window and click on Debug & Compile, It highlights .cboAccount in this line: If IsNull(Me.cboAccount) Then Exit Sub...
Sponsored Links:

More topics


How to determine why Access is unable to create an MDE database

I tried to compile my MDB database into an MDE file, but I received the error: "Microsoft Access was unable to create an MDE database." There weren't any other error messages. How can I find out what the problem is?

MS Access 2003 Database as exe file

I created a database using MS Access 2003 and I want it make to MDE file but when I click the Make MDE File I got the pop up message like this:

You cannot create a Microsoft Offiece Access ADE or MDe file from a
database saved in Microsoft Office Access - 2000 format

Convert the database to the current version of Microsoft Office Access. Then create the ADE or MDE File.

When I check the Tools>Database Utilities>Convert Database>To Access 2000 File Format it was disable or grey out. I don't know why:confused:

What should I do? or what configuration I need to do

How to Convert an MDE to an MDB

If you've written an MDB database file, and you want to let other users perform applications with it, but don't want them to change any codes, change it to an MDE file, another type of Microsoft Access file. In MDE, however, you can't change how the database and macros work. Learn how to convert the MDE file back to an MDB (modifiable) file.

MDE Does not Look Like MDE?

I have a MDB file which I publish as MDE for users. I have noticed that the MDE file does not quite have the same charachter as other MDEs as I can see nearly every single object which are normally non editable. Is there an explanation for this

Cannot create ACCDE file

I receive the following error message when I try to create an .accde file. "Microsoft Office Access was unable to create the .accde, .mde, or .ade file." When I click on Show Help this is the message contained in it:

"This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."
From reading this, could the issue be that we have too many tables, forms, and queries existing in the database to be able to create the .accde file?

2007 MDE will not Open in Access 2003

I have an Access 2003 database that I work on using Access 2007. When I get ready to save it for distribution, I click on the Database Tools Ribbon and then on "Make MDE". It appears to make the MDE database.

However, when I try to open it in Access 2003, it says it cannot because it was created in a higher program.

My work-around is to take the Access 2003 MDB to a computer with Access 2003 and make the MDE file. However, this is a pain.

Am I correct that Access 2007 will not make a working MDE file from a 2003 database. Or at least an MDE that can only work from Access 2007.

It this is correct why put the MDE button there?

Converting a Microsoft Access Database to an MDE File

The situation may arise when you quickly need to secure and distribute a Microsoft Access database that also contains Microsoft Access VBA code. You will protect the database from editing by restricting the database users access to the design views, however you will need to allow the users to process their data as normal.
It may be that you haven't got the time to fully create Microsoft Access User Accounts or to set Microsoft Access Security Permissions. By knowing what can and cannot be done by using the Microsoft Access MDE file format, will allow you to make a decision and to quickly release a secure database to the users.

How to make design changes to an Access MDE file

A common question in Access database newsgroups and forums is 'How can I convert my Access database from MDE format into an MDB file?' If your file contains VBA code then the correct answer is that you can't since the MDE file is locked and protected. However, the protection isn't the main obstacle in trying to convert the MDE file, the main issue is that all VBA modules are saved in a compiled state with any original source-code being stripped out.

mde file in Access 2007

I have just converted a mdb database in Access 2007 to a mde file, but now the said database does not work correctly. When I opened up the mde database, I got a message from Access 2007 saying there was a potential security concern, and I clicked the ok button to open up the database. Now the combo box to find records does not function, as when I select a record from the list, it is not shown on the form.

can't create .mde (error 31675)

I'm trying to create an .mde out of my front end, but when I do, i get an error saying:
"You cannot create an .accde or .mde file from a disabled (non-trusted) database. If you trust the source of this database, you can enable it by using the Message bar."

I assume this is talking about the security warning that pops because of VBA Macros? If so, then how can I create an .mde file if I have all the menu's hidden in front end?