Results 1 to 4 of 4
  1. #1
    MFS is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235

    Access 2010 will not allow me to make ACCDE

    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.

  2. #2
    MFS is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235
    Wow this makes twice today I figured my problem out shortly after I asked for help.
    After compiling the db I found I forgot an 'End If' at the end of my VB
    Thanks again all of you

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Typically the problem is code that won't compile. In the VBA editor, Debug/Compile until no error is found.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Oops, too slow. Glad you found the problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  2. Replies: 9
    Last Post: 04-20-2012, 08:13 AM
  3. Unable to make ACCDE
    By jhargram in forum Access
    Replies: 5
    Last Post: 04-10-2012, 11:14 PM
  4. Cannot make ACCDE
    By DanW in forum Database Design
    Replies: 1
    Last Post: 12-10-2009, 08:20 PM
  5. Make ACCDE problem
    By Eric1066 in forum Access
    Replies: 3
    Last Post: 11-27-2009, 04:33 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