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? Any help you could provide would be much appreciated.

Thanks,


Post your answer or comment

comments powered by Disqus
Dear members,

my recently "robust" application was changed (Forms, Tables, Queries). Ever since I reconnected to the Live Back-end data, I have been experiencing some issues:

1. multiple requests for the password, and then, states not a valid password. On the re-attempt, the password is fine!
2. Cannot create an ACCDE file --> it does the password "loop" and then fails to create the ACCDE.
3. I cannot change or remove the password.
4. I now cannot compact my Db either --> once again, the dreaded password "loop".

any suggestions why my Db has become unstable?

i try to create accde file in access 2007 but he give me this msg " microsoft office was unable to create .accde,.mde or .ade file"

Hello
Its is possible create a log file with all logging process inside a ACCDE File?

I need to know what happend inside my Database File. Like a Log File.
Can be possible?

Thanks

Hi,

I am new to Ms Access and came across this problem. I am working on Windows 7 and using Ms Access 2010. I have some tables in an accdb file. Some of them are link tables which link to tables in another database and some of them exist in my accdb file. When I create an accde file from my accdb and copy the accde file to a location under program files for example,

C:Program Files (x86)MyFolder

When I open this accde file and try to edit in non-link tables, I am unable to do so. I cannot add or delete from the tables. It seems they are locked somehow.

But when I copy my accde back to some location other than C:Program Files (x86)MyFolder , I can edit the non-link tables again.

What seems to be the problem here? Can any body tell me, how can I be able to edit my tables when the accde is located under C:Program Files (x86)MyFolder.

Thanks

Best regards

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

Hi,

I am using an Access 2007 database. I have several reports created in Access, in that are all sent out through Outlook as rtf attachments using the SendObject method:

DoCmd.SendObject acSendReport, "My Report Title", acFormatRTF, RecipientEMail, , , , Email Message, True, False

I send all messages from the same form and in the same way. It’s been working fine for over a year. Yesterday, one user received this message when trying to send one particular attachment.
Microsoft Office Outlook message that says:

Cannot Create File: MyFileName.rtf.
The message then says to check permissions for the folder I want to save the file in.
Only the one user has the problem. Her front end db is on her hard drive (back end on network). All of her other attachments are sent with no problem. I checked the code on her copy of the db and nothing has been changed. She is able to create the rtf herself, attach it and send it. The only difference between this attachment and all the others is that it is somewhat larger.
I don’t actually save the files that are sent as attachments, and I don’t know enough about Access and Outlook to know if there is a temporary file created to hold these attachments until they are sent.
Has anyone seen this before? I would greatly appreciate any help you can offer.
Thanks so much.

Pat

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?

Hi All,

I created a database for a department in our company to track the projects they work on (15+ users). In order to protect the data and design, I split the database and also created an .accde file for production that the staff use from a shared location.

Today, I noticed that the production .accde file was unusually large at 128MB. My back-up .accde file is 3.3MB, so I tried using that to overwrite the production db, which worked; however, the file size increases back to the 128MB once someone opens it again. The back-end (_be.accdb) file is about 5.6MB and my database pre-split was only 31.3MB.

The database has been in use since the beginning of 1st quarter and I've never seen this before. Any ideas why this might be happening?

Many thanks!
-L

Greetings,

I have a database I have been developing for some time that I can no longer access. I am running windows XP and Access 2003, I am the only user and it is stored on my local system. I was tweaking some VBA code in a few of the forms and closed the file which triggered the auto compact/repair. Everything appeared normal until I tried to open it again later. Now I cannot open the file, I do not get an error message or anything. When I click on the file Access opens and stops, never actually opens the database. If I try to open the file inside Access nothing happens. I have tried importing the objects into a new DB and still nothing happens inside Access. The real wierd part to me is that outside of Access everything is accessible. I can import tables from inside Excel with no trouble, I can put a button into a blank database that opens the other database through DAO and I can see all my tables, forms, data, etc. My problem is that I do not need the data, it is just test data at this point, I need to recover the VBA code from the Forms and I do not know how to do that without being able to open the database in Access.

Here is what I have tried so far (on copies of original DB):
-Compact and Repair inside Access: Nothing happens just like trying to do anything else with it inside Access
-Opened DB holding shift: Same Problem
-Copied file to two other Windows XP/Access 2003 systems: Same problem
-Used Jet Compact: The database file compacts successfully, still cannot open in Access
-Opened Access with /decompile: Same problem, Access opens, DB does not
-Created new DB and tried to import objects: Cannot open the old DB or see its objects
-Imported data from inside Excel: No problems, all tables/queries are available and all data appears correct
-Accessed file from new DB using DAO code: Everything appears normal, I can export the modules to text fine, but I have lots of code in forms that I cannot export
-Opened other databases in Access on same machine: No problems

I've done quite a bit of searching on this and have not found the same problem listed anywhere else. I do have daily backups so I'm not completely lost, but I made quite a few changes before it died that make it worthwhile for me to try and recover the file.

Any suggestions of other things to try? Is there any way to extract the VBA code inside a form from an .mdb file outside of Access?

Thanks for any ideas!

I have a DB that I needed to modify. I went to the original, unsplit accdb file, made changes to forms, and created another accde file and published it. all files were kept in the original location. When I then open a form none of the VBS scripts run. I have event procedures setup for "on load, on dirty, on click, etc. The form changes are there but the code doesn't run. The location of the files is set in the Trust Center. When I run the original DB in the accdb format, everything works great.

To TS, I created a new DB and imported in the tables, forms, queries, etc but still would'nt run. I setup a lab computer with no group policies and tested, didn't run. Logged into the local workstation and not the domain, still no good.

I've upped the permissions on the folder where the files are, no good.

Tried everything I can think of. Any thoughts anyone?

chris

I have created a accdb database. It has been split with a back end and a front end. It has record locks on each form:

Private Sub Form_Load()
Me.AllowEdits = False
End Sub

I placed the link to my front end database on our company website so that our Supervisors can use the Form Buttons to see prior data production, late items, etc.

When I was using the link to a .accdb file it wouldn't allow more than one user or we receive the message "You do not have exclusive rights, etc."

So I then saved the database as a .accde file. It allows multiple users but does not keep the record locks on the form, the supervisors can alter the data. I want to lock the form as far as editing the data but I still want them to be able to filter the form and then export the data to excel via a button at the top of the screen.

Please help! Thanks!

I've eliminated most of my runtime errors, declared all my variable and created an ACCDE file, but when I open the file I get the following error.

The expression On Load you entered as the event property setting produced the following error: The command you specified is not available in an .mde, .accde, or .ade database.

There are only two On Load events taking place. The first comes from the default form. It calls a couple procedures, one of which opens a report with an On Load event of its own. Neither of these events has caused problems before. Since the form calls the Report and both open I'm guessing it's the Report code that is not working.

Update: I took out the On Load event from the report and am still getting the same error. In addition I've tried out some of the other buttons and am getting the same error on the On Click events. Some of the option button and frame events are working, but not the guts of the program.

Code: Private Sub Form_Load() Me.fraDateRange = 2 DoCmd.OpenReport "rptCropYield", acViewReport Call fraDateRange_AfterUpdate Call cmdRefresh_Click End Sub Code: Private Sub Report_Load() DoCmd.Maximize End Sub

Hello,

I have created an inventory database that other users in our company will be using. It was suggested that I try making a ".accde" file to keep users from being able to accidentally change components in the database.

I am new to access so I am learning as I go but will the original .accdb file and the new .accde file be linked? For instance, if I change or add something to the .accdb file will it be reflected in the .accde file?

Thanks in advance!

Hi All,
Does anyone here have encountered the same problem I am facing right now where I could not convert my Access 2007 to ACCDE file? The following error appeared:
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.

Thanks and Regards,
Teejay

I am using the following code to determine if Excel is open, if it is open use that session of excel to do the following, if it is not open create a new session of excel. I have checked all of my available references and they are all checked and none are listed as missing. I am able to use createobject if it is not in an if statement and same with get object, but together I get the ActiveX component cannot create object 429 Error. Can suggestions on how to correct or another code they may work? thank you. Also i have read some of the knowledge base articles and tried those solutions without result. Thanks



	Code:
	Option Compare Database
'-------------------------------------------------------------------------------------------------
'-----------------------------------------------------------------------------
' Procedure : Send2Excel
' Author    : Bob Larson
' Date      : 5/25/2008
' Purpose   : Send any single recordset form to Excel.  This will not work
'             with subforms.
' Use       : You may freely use this code as long as the author information
'             in this header remains intact
'-----------------------------------------------------------------------------
'
Public Function Send2Excel(frm As Form, Optional strSheetName As String)
' frm is the name of the form you want to send to Excel
' strSheetName is the name of the sheet you want to name it to

    
    Dim rst As DAO.Recordset
    Dim Apxl As Object
    Dim xlWBk As Object
    Dim xlWSh As Object
    Dim intCount As Integer
    Dim stDocName As String
    Const xlCenter As Long = -4108
    Const xlBottom As Long = -4107
 
    Set rst = frm.RecordsetClone
    Set Apxl = GetObject(, "Excel.Application")
    If Apxl Is Nothing Then
    Set Apxl = CreateObject("Excel.Application")
    End If
    
    Set xlWBk = Apxl.Workbooks.Open("N:EvalCardevalcardsheet.xls")
        Apxl.Visible = True
        Apxl.Run "first"
    
    Set xlWSh = xlWBk.Worksheets("Sheet2")
    If Len(strSheetName) > 0 Then
        xlWSh.Name = Left(strSheetName, 34)
    End If
        Apxl.Run "second"
    xlWSh.Range("A1").Select
    Do Until intCount = rst.Fields.Count
        Apxl.ActiveCell = rst.Fields(intCount).Name
        Apxl.ActiveCell.Offset(0, 1).Select
        intCount = intCount + 1
    Loop
    rst.MoveFirst
    xlWSh.Range("A2").CopyFromRecordset rst
    xlWSh.Range("1:1").Select
    ' This is included to show some of what you can do about formatting.
    ' You can comment out or delete any of this that you don't want to
    ' use in your own export.
    With Apxl.Selection.Font
        .Name = "Arial"
        .Size = 12
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
    End With
    Apxl.Selection.Font.Bold = True
    With Apxl.Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .MergeCells = False
    End With
    ' selects all of the cells
    Apxl.ActiveSheet.Cells.Select
    ' does the "autofit" for all columns
    Apxl.ActiveSheet.Cells.EntireColumn.AutoFit
    ' selects the first cell to unselect all cells
    xlWSh.Range("A1").Select
    Apxl.Run "opennewbook"
    DoCmd.Close acForm, "EvalCard"
    rst.Close
    Call sTestSleep
    DoCmd.OpenForm ("EvalCard"), acNormal
    Exit Function
err_handler:
    DoCmd.SetWarnings True
    MsgBox Err.Description, vbExclamation, Err.Number, Erl, vbCritical
    Exit Function

       
End Function



How can I trap the error "The Microsoft Database Engine cannot open the file 'MyDb.mdb'. It is already opened exclusively by another user, or you need permission to view its data".

I have an error handler in my routine, but it does not get called at all when this happens. Instead, I get a msgbox with the text shown above, which of course just hangs up everything until I click OK.

I am trying to create a folder and name it after a single record that is loaded on my form. Every time I create the file it overwrites it with new information. What I need it to do is create the folder with a specific name (preferably a contact name) so a new file is created for each record rather than rewriting the same record every time.
Unfortunately it is the weekend and I do not have the code at this time but if anyone has suggestions as to what I can try I would appreciate it. Thanks!

Hi..anyone here knows how to solve this "ActiveX Component Cannot Create Obj"?
I've actually tried to go to the microsoft website and have followed the instructions to register the DAO, and it said DAO has been registered successfully, however this "ActiveX" Problem still remains....
What can I do to get rid of this???
I;ve tried uninstalling it ,remove the DAO and install it again but still does not post any help.

Anyone knows whats wrong??

Hi,

I have an Access 97 database that uses docmd.transfertext to import three text files when the use loads a particular form. It works fine.

The line is:

DoCmd.TransferText acImportDelim, "importProjects", "Projects", thisFile, False


Now that I'm about to install the same db in Access 2000 I get problems.

Specifically:
Run time error '31519':
You cannot import this file.

What happened? And more importantly what can i do about it?

Thanks

I'm stumped.

I saved my ACCDB file as an ACCDE for another version of my app. Previous versions of ACCDE work fine. This time, anything that requires VBA does not work. It's like VBA modules are not there.

When in the ACCDB version of the file, everything works fine. In the ACCDE everything is visible, including the Code Modules, of course they can't be opened as it's an ACCDE file. Everything works, except things that need VBA.

For example, one form loads fine, but a portion of it doesn't get populated because it's reliant on VBA. Command buttons don't respond, etc.

I can't think of anything I've changed since the creation of the last ACCDE that could cause this.

Any ideas???

This is a first for me in my short experience with Access. Any insights much appreciated.

Thanks,

Shred

Hi there,

I am getting an error when i try to make an MDE file I have a database that is split into forms and back end tables. I get an error that i have too many forms or modules( i only have around 30 forms) , is there a limitation to the number of forms or module you can have in order to successfully make and MDE file.

Thanks

Access writes when I try to create ADP file having only MS SQL EXPRESS SERVER 2005. MS Access 2007 writes it does not see server. What to do?

I have built a report using a stored proc as the data source. The report has been deployed and I can run it from the reporting services site. I have admin rights. But if I logout and login as a general user I get the following error. "An error has occurred during report processing. Cannot create a connection to data source "DataSet2"."

I'm stuck and not sure what to do. Is it something to do with permissions?

I have a ACCDE file and I need to Export all the data on this ACCDE file for insert into a new db.

What I need to do? Exist any utility for do this? Thanks


Not finding an answer? Try a Google search.