Related Topics

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

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?


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.


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?


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?


Access .mde Security Issues
I have a dozen or so users who are using Citrix to log into a .mde Access database. This database has no linked tables, simply a .mdb version in the same directory. It has user level security also.

The problem is when a particular user logs in and then exits again, the .mde file security is taken over and the administrator has to give everyone back their permissions in Windows Explorer under the file security tab.


Access .mde Security Issues
I have a dozen or so users who are using Citrix to log into a .mde Access database. This database has no linked tables, simply a .mdb version in the same directory. It has user level security also.

The problem is when a particular user logs in and then exits again, the .mde file security is taken over and the administrator has to give everyone back their permissions in Windows Explorer under the file security tab.


Unable to view code & module in a database
I have just checked out following link where there is a sample .mdb file which track idle time and logout user from the database after a certain time.

Could anyone help me out to view the codes and modules in sample file attached (HRForm.zip) in below link as I am unable to view anything. Its also doesn't seems to be .mde format.

Also like to know how this can be done to hide everything (forms, query, tables) in a database. without converting it into .mde format (Attached file has a good example on this


Getting an MDE to work on the server
I know how to create the MDE file, and it opens fine on my PC when accessed via our network and on our Exchange server. But my colleague, for whom this was created, in large part, cannot open it. The icon doesn't even really show up. What needs to be done on the server or on her machine to facilitate this? I'm using Access 2007 to build the database. She does not have Access on her PC, but from my experience, that's the whole point of an MDE


Unable to make ACCDE
When I click that button it will give some error msg. like "Microsoft office access was Unable to create the .accde, .mde, or .ade file".

I am using Access 2007.
file type .accdb


How to get data out of Access MDE files?
It was a self contained application. All I have are the two MDE files. And they are full of data now. The app requires a login. I want to export this data into another database. How can I get the table structures and the data out of the MDE files?

A new version of Access? Sql Server? .NET? A data conversion tool?

Oracle says that if they have the XML file with the table structures, they can export the data: Is there a way to get the XML file from the MDE file?


Unable to make ACCDE
how i prepare ACCDE file, when i click that button it will give some error msg. like "Microsoft office access was Unable to create the .accde, .mde, or .ade file".

Can anybody help me to resolved this issue..
I am using Access 2007.
file type .accdb


Access 2007 MDE file
I've been using Access 2000 for too long and have now loaded version 2007.

After changing just about everything in the old 2000 (.mdb) database to 2007, it now works fine.

The problem I have now however is not remembering (probably old age) if the mde file works on a user's machine that does NOT have Access 2007 installed on it.

I have made a new mde and it works okay on my machine for obvious reasons.

I'm certain that they used to run in the older version.

Access 2007's Help file doesn't even recognise "mde" as a search query, and I need some real


Making mde file of the FE
I have designed multi user application which will be used by around 8 people simultaneously and now I want to deploy the FE to each workstation. Can anyone please tell me before I deploy the application to users,shall I compile the FE mdb into an mde file? What are the benefits of this? Will it increase processing speed as now the system does miss some records when bulk insert occurs on multiple computers.

And also when I go to tools->database utilities then there is no "make mde file option" present.


Converting Access Database File to a MDE File or ACCDE File
To help lock down and prevent certain objects especially Forms, Reports and any code being modified (via the design mode), you can convert your database file into an ‘executable‘ file format where the .MDB becomes a copy as an .MDE and the .ACCDB to a .ACCDE.