Results 1 to 4 of 4
  1. #1
    MSAccessNewbie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2019
    Posts
    2

    mydatabase_be.accdb auto created

    When I open the DB "mydatabase", the following files are auto created - "mydatabse.laccdb" and "mydatabase_be.accdb". I know what the .laccdb file is and I assume the mydatabase_be.accdb is a backend DB, as there are numerous tables linked to this file. The DB functions properly and there are no issues. When you close the DB both files are removed and this leaves just the main DB file "mydatabase.accdb".

    When I copy this DB to a different PC and open it, the file "mydatabase_be.accdb" is NOT autocreated, and therefore the DB is unusable.

    My questions is - where can I find how "mydatabase_be.accdb" is auto created? I assume there is some automatic process that does this but I cant find any Macros and not sure where else to look



    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's unusual for the back end to be created on the fly like that. I'd look for code in an autoexec macro or in the open/load event of whatever form opens when the db is started. Does the back end start out empty (no records)?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    MSAccessNewbie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2019
    Posts
    2
    I checked the on open/on load events for the form that opens when the DB is started. There are 2 embedded macros (On Current and On Open, On Load is blank) but they are getting info to populate that form.

    I have gone through all the macros and do not see anything that would generate the back end file, nor named AutoExec, I assume it would be listed with all other macros? I also checked Access Options to verify the form I see when the DB is started is the one listed in "Display Form" field.

    The back end does contain 2 tables with records once it is created.

  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
    That's very fishy. Can you attach the front end here?
    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. .accdb vs. .accdt
    By VAer in forum Access
    Replies: 9
    Last Post: 08-09-2018, 09:17 AM
  2. Replies: 4
    Last Post: 06-11-2018, 03:22 PM
  3. Auto Tables created by Access
    By donsi in forum Access
    Replies: 3
    Last Post: 09-05-2016, 09:06 AM
  4. .accdb and .mdb
    By vruchtvet in forum Access
    Replies: 7
    Last Post: 05-27-2016, 04:05 AM
  5. ACCDB vs ACCDE
    By data808 in forum Access
    Replies: 8
    Last Post: 01-09-2014, 04:39 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