.MDE file Microsoft Access was unable to create an MDE database
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...
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
"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?
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?
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.
"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?