Results 1 to 6 of 6
  1. #1
    Teejay is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    6

    Could not convert my Access 2007 into an ACCDE file

    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


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you know for a fact that your project will compile? Try importing the db into a new empty db and then test again. Not all error messages are accurate.

  3. #3
    Teejay is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    6
    Nope, I still cannot convert it. I am working a dozen of different modules into 1 database Access 23007 and has imported few Access old version MDB templates.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  5. #5
    Teejay is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    6
    I did try to import it twice but finally figured it out. It was only the 'compile' issue that I failed to perform prior to converting it to ACCDE file.

    Anyhow, thank you for your help RuralGuy.

    Regards,

    Teejay

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. I guess this thread is ready for you to use the Solved thread tool now. Just follow the link in my sig for instructions.

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

Similar Threads

  1. Replies: 32
    Last Post: 09-16-2009, 10:06 AM
  2. Convert query sql server for Access
    By webtony in forum Queries
    Replies: 0
    Last Post: 06-23-2009, 02:46 AM
  3. Convert Excel Macro to Access Query
    By crownedzero in forum Queries
    Replies: 1
    Last Post: 06-22-2009, 02:13 PM
  4. Replies: 0
    Last Post: 12-28-2008, 01:56 PM
  5. converting from Access 2003 to Access 2007
    By LawrenceLau in forum Access
    Replies: 6
    Last Post: 11-20-2008, 03:53 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