Results 1 to 6 of 6
  1. #1
    Dan Hugos is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Location
    Jim Thorpe, PA
    Posts
    28

    Access 2010 "Unable to Create ACCDE"

    Today's stumper question:



    I have a database of moderate complexity that compiles fine, but which I cannot save out to ACCDE. I get the message, "Microsoft Access was unable to create the accde, mde, or ade file."

    I have tried importing everything into a blank database, resetting the options, and re-compiling, which I can do successfully, but I still get the same message when I try to save to accde.

    The file has the same references as several other databases which I have saved successfully out to accde. I am using Windows 7, 64-bit, Access 2010, the tables are connected SQL tables using Native Client 10 (other dbs using the same thing with connected SQL saving out to accde just fine).

    Please, someone ...

  2. #2
    Dan Hugos is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Location
    Jim Thorpe, PA
    Posts
    28
    Well, I guess I answered my own question. I think it can be a few things that cause this problem, so the key is some patience.

    I created yet another import file, and made sure I did not import the various MSYS tables from the database in question.

    I think if you have an msysmodules and msysmodules1, for example, that it causes mysterious problems, even though your database will indeed compile if you do accidentally have them. I saw that they were being imported the first time, so I made sure not to import them, and voila, the save to accde process worked.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,858
    Thanks for following up with the solution, and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Dan Hugos is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Location
    Jim Thorpe, PA
    Posts
    28
    Many thanks. And I like that - "wino moderator."

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,858
    I haven't yet figured out if I'm a moderator who's a wino or if I'm just in charge of the winos.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    Dan Hugos is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Location
    Jim Thorpe, PA
    Posts
    28
    LOL, maybe both! Keep up the good work!

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

Similar Threads

  1. Replies: 1
    Last Post: 01-02-2015, 05:04 PM
  2. Replies: 1
    Last Post: 01-16-2014, 12:33 PM
  3. Replies: 2
    Last Post: 01-15-2014, 07:57 PM
  4. Replies: 22
    Last Post: 10-10-2013, 12:47 PM
  5. Replies: 2
    Last Post: 11-04-2011, 02:45 AM

Tags for this Thread

Posting Permissions

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