Share via

MS Access 2010 Changes database name when I close

Anonymous
2012-10-05T13:54:21+00:00

I am using MS Access 2010 on a XP workstation

When I exit out of the database I am using the file changes to Database1.mdb

Why and how do I change this?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-10-05T17:51:33+00:00

    That may be it...I had it set to Compact on CLose on a server...and we do have a crappy connection...I'll try it out...thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-10-05T16:44:32+00:00

    A name change like that usually indicates that Compact on Close is enabled and the database is not compacting properly. But the original file should still exist unless the compacting was so messed up that the entire file just vanished.

    Compacting can fail if the file is large and the compacting is done while the file is on a server with an inconsistant conenction.

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2012-10-05T14:02:43+00:00

    That is not normal behavior. Can you duplicate that with a new empty database?

    Also make sure that in File > Options you have Compact on Close unchecked.

    Was this answer helpful?

    0 comments