Results 1 to 2 of 2
  1. #1
    swilliams is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    1

    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,

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Any error while compiling will cause the problem you see. Try going into any module and then Debug>Compile. If you get any errors then they need to be fixed first.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create a history file
    By Thomman in forum Forms
    Replies: 10
    Last Post: 04-19-2010, 08:52 AM
  2. Create Hash - Copy File to string
    By andrew_ww in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:14 AM
  3. Cannot make ACCDE
    By DanW in forum Database Design
    Replies: 1
    Last Post: 12-10-2009, 08:20 PM
  4. Replies: 5
    Last Post: 10-24-2009, 01:16 PM
  5. Create a command button to Browes for file
    By sawill in forum Programming
    Replies: 3
    Last Post: 03-15-2009, 05:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums