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


Post your answer or comment

comments powered by Disqus
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

Hi – I am relatively new to Access and am using Access 2010 macros in my database. The db works well [it seems?] when running on my ‘full’ version of Access 2010.

However an error occurs when I attempt to run the same db on either:
a) A PC running Access RunTime , or
b) When the db is compiled into an executable – i.e. make ACCDE [Through ‘Save & Publish’]

The error message when running (a) or ( b) is “settempvar is not available etc..”

My theory is it is the same error cause? May be (a) or ( b) are the same in that the software is converting my macro code to vb and it is the vb that is in error - but please feel free put me right on this ?
To test my theory I used the Access provided ‘Macro to vb converter’ to convert one of my Macros to vb and found that this new vb code errors, whereas the Macro does not?

I think I have narrowed one of the problems down to where I assign a TempVar to equal an existing TempVar. – see example attached- The converted VB is in error – see message in the attached.

I hope the attached example is sufficient for you to provide some advice and guidance which would be very gratefully received. Many thanks in anticipation..
Rgds David
NB Surely it will not be an error in the Microsoft provided ‘converter’ ?

Hello all

I have an Access 2010 front end to a SQL Server 2008 R2 Express database that has been created and worked on using Windows 7. To distribute the front end to other users in my office I've used the 'Make ACCDE' feature and have then saved the front end on other machines that have the Runtime version of Access installed.

This all works fine on other Windows 7 machines, but it doesn't work on Windows XP machines.

I came across this problem a little while ago and found some posts on a couple of forums about this being a known issue and I think that there was a work around. But now that I'm trying to resolve the problem I don't seem to be able to find the same posts that I had seen before!

Can someone please point me in the right direction.

I think I recall that one option is to create the ACCDE file on a Windows XP machine running Access 2010, but if possible I'd like to do it all on my Windows 7 machine as I don't have a Windows XP machine with a copy of Access 2010.

Thanks in advance
Speedball

Hi,

I've got a really simple Access 2010 database app [not Web] that I want to distribute and I have a few questions about that.

I am still working on a few features of the app and expect that I will be for a couple of months while it is being used.

Right now - my users all have MS Access 2010 and are using that to open the database. I don't expect any of them to know how to open in design mode - or have the time to play around as they are always really busy with other work.

But . . .
1. What is the easiest way for me to deploy so that users cannot get into design mode?
2. Is there a preferred method - other than the easiest way?

I just tried using the 'Make ACCDE' option and got this error message:
Microsoft 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 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. It's a small database - and there are only 6 Forms and 5 tables [with very little data in them right now . . .

I have tried following some other methods [splitting the database is one] and am not sure which one I should focus on.

I'd prefer they don't have the ability to get into design mode. And I like the idea of the data being in a separate location so I can just distribute the changes as and when I make them.

I'd appreciate any suggestions.

Thanks!

Robin

Anyone who can help!

I've made a program for making sales and so on, and now when it's ready, when I try to make an accde file (Access 2007 executable) it replies that I cannot make that because it can make only "2048 TableID"s at the same time. What that means and what I have to do? I have only 1 form that is "module on" property. And 60 forms in total. For me it's not possible to delete some of them. All they are needed. What I have to do? Is it possible to transsphere some forms to another file and then use both of them while converting both to accde?

Hi Folks

I crated this post here -

http://www.access-programmers.co.uk/...d.php?t=189068

It was ref splitting the DB (front end and backend)

This is working well and I'm happy.

Is it a good idea to make a ACCDE file from my front end to really restrict what my users can do to forms etc?

Or can I not do this on a split database?

Actually whilst writing the thread I tried it and it seemed to work OK.

But is it a good idea?

Regards

Jimmy

PS I really appreciate all your advice


Not finding an answer? Try a Google search.