make ACCDE


Dear all,

i recently converted an old 2003 DB into 2007 and am trying to make an executable file to run on PCs without Access 2007 installed. When I tried making an ACCDE file - I received the following error:

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).

I am working through all the differences of 2007, but cant seem to make this work.. if anyone can put me out of my misery........

thanks, mark


Sponsored Links:



Under what circumstances would the "Make ACCDE" icon not be available in the Access toolbar?

I have an split database with an encrypted BE and I wanted to compile the FE, but the button just is not there...

Using Access 2010

suggestions?

Thanks

mafhobb




Hi all,

I have query regarding the "make accde" functionality in the Access 2007 database.

My Db size is 100MB. I want to hide the VBA code from the users by converting my accdb file to accde file. But when I use the Database Tools-> Make ACCDE option, I am getting the following error.

When I imported only one main form in the current DB to a new Db, i am still getting the above error. But when I import all the tables and queries and perform the conversion, it is successful.

Can anyone help me to know whether it is possible to convert the DB into accde with forms?

Thanks in adavnce.




I've reviewed several solutions listed on this web site and have knocked off everything I could find to the site.

I do not see the Make ACCDE button. I'm using Access 2010 32 bit. Have an ACCDB FE file which I'm trying to create the ACCDE. I've compiled and fixed the VB errors. I've review trusted sources and insured the folders are trusted. For whatever reason, the button is not showing. Any ideas?




Want to distribute an Access 2007 program. Making accde file to protect forms, tables, queries, vba, etc.

After converting the database, forms don't seem to work (display form, my dashboard/main menu, etc.)

Is there some other step that needs to be done before compiling the database?




Hi,

My db is finished. It is only 2 tables and three forms. but when I click on the make accde option I get the following error:

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.

This cannot be the problem, it is not a big db and I was able to make it about an hour ago.

Any help id greatly appreciated!!
Eric1066




I hope this is the right forum but please advise if not. I am using Microsofts new 2010 beta version of Access. I want to distribute a very simple database that records time spent ona job and calculates the invoice and prints an invoice report. I want to make an executable file of my database so that people without MS Access can use the database. This is not a commercial thing. However, when I try the share option and choose the make accde file or similar file access says it can't create it - help says usually because of the number of table IDs. This is really a very simple and small database with only 5 small tables. Can anyone help or tell me how I can get round this problem please?




1) I am trying to make an ACCDE file from my existing development database and I am getting and error message stating it can't do it. When I select help from the little menu that appears this is the message.

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 TableIDís 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 TableIDís 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 TableIDís are used.


I have 26 tables, 20 queries, 44 forms and 14 reports. I am not trying to save it as MDE but ACCDE.


2) Is there a way for me to copy my entire database structure only without the test data in it to a new database. What I am looking for is to reset the autonumber id fields back to 0 and load with fresh data?




Hi all,

I have developed my DB. I want to lock-down the DB to users, and, make the file exclusive to avoid duplication of records and other associated errors.

I have gone into the 'Advanced' 'Access Options' and checked the 'Default open mode = Exclusive'. Alas, this does not work. I do not want to rely on my users opening the DB by using the arrow icon on the Open button - they will probably double-click the ACCDE icon anyway!

Any help always appreciated.




Please i need help on my database to make it accde it's complaining about "method of compiling which is associated with large database"
any help.

this is 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."

what can i do

thanks




Hi,
I need to distribute my Access application (2007) so that about 5 users may use this at once. However, I always heard that you have to split the database and then make the accde. However, in this case, I would prefer not to split the database if I can avoid it.
Do you have to do this? Or can you just make accdes and distribute them of the one database?
Thank you




I need some advice on the best direction to go.

I finished a large project, 15 tables, 150 queries, 150 forms, 10 reports, and could not make an ACCDE file in Access 2007.

The error message reads:
Microsoft Office Access was unable to create the .accde, .mde, or .ade file. 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 Table IDs 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 Table IDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one Table ID, 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.

So I did a lot of normalizing and increased the tables to 20, with a great deal of remaking the queries to remove about 50 foreign keys, as in Car1, Car2, Car3, etc., by making linking tables.

Tried to make an ACCDE file and got the same error message.

My question, do I really need to prune back the number of forms, which will limit the scope of the project (80% are dialog or subforms), or could this be gremlins from my normalizing the database where I need to build a virgin database?

Also, how important is this obstacle? I was just getting ready to split the database for my office server, I haven't done before. Is there a way to work around this.

Another problem I'm having is that Windows 7 Pro is not letting me switch the file from an accdb to an accdr form. The new explorer is not letting me do it the way XP did. Headaches, since I have a great accdb that I cannot evaluate in runtime.

Appreciate your help,

Dan




Is there a way to progammatically convert ACCDB into ACCDE file format?

Can someone provide a code to do it?




I am using Access 2010 with Windows 7. I wanted to deploy my app to user and I thought "Make ACCDE" would do that. But after I executed the compiled executable file, I can not get my reports to run or display. I did check the queries and they are working. Does anyone have any suggestions?

Correction: Reports are working. But I am unable to run reports from menu.

I select report option from menu then next form let's me enter report date range and upon clicking OK button, I should be getting a report. Now when pushing button, I get no response......




Hai there,

I really appreciate if someone help me to sort the following problem. I am using Access 2010 and having some problems when converting the database to ACCDE. It's a split database which we use it in our company Network (share drive). Whatever codes used in the forms "on load" event is not working when I convert the database to ACCDE. Such as, code for password to open a form, hide the ribbon etc. But all these are working on the normal database!!!!

Can anyone tell me what I am doing wrong?

Thanks in advance and regards

Problem Solved; Just re-complied the code in VB and everything start working fine. Thanks for pointing to the right thread!!!




Not sure what is going on, My database is very small 5 forms, 3 tables with no data at the moment and when I try to make it executable I get the following error . . .

"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."

I pray someone can help with this problem.




Hi,
I just started a new job and I had to make an enhancement to an Ms Access 2007 application. When I was done the accdb works great, but I noticed that they had it as a accde that the users use. I made on by going to the Database tools then to Make ACCDE and made it. However, when I open it you cannot click on any of the buttons; you can only X out of the application.
I went to another folder where I have sample databases applications, made a accde out of them and they worked fine.
Any ideas of what is happening and what I can do would be greatly appreciated.
Thank you
itm




Hi All---Please advice me 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


Thanks in Advance..




Hello,

I have created a database for my company. I want to limit the permissions end users will have. I want to lock all design to the database (similuar to make ACCDE) however I want to re-enable design permissions to administrators, this would be done via a button on the form prompting a password.

I know this is possible because I have seen this in databases, however I do not no how to do the same, I can make it ACCDE which is great however as far as I understand I cannot achieve what I want above.

Any help is greatly appreciated.

Regards,




Hi,

very strange and annoying issue.

i have one created database. this is split and the front end is .accde.

i have 2 computers. both running Vista and access 2007 ( same version ).

i can install my database quite happily on computer one and the file is placed locally so there is no sharing involved at all.

when i install in on computer 2, i get this message

the database cannot be opened because the vba project contained in it cannot be read ( see full error attached )

if i copy the database form computer 2 to computer one, it works!!
if i open the accdb on computer 2, it works. just not the accde.

ive been through my code and compiled it. why will it happily work on one pc but not the other whenthe same file is being used?

also,

if i place the accdb on computer 2 and make accde from it, the accde works just fine.

is it a permission issue?



regards & frustrated and confused,

Nidge