Home > IT Answers > Microsoft Windows > Database being auto duplicate when exit.
Nurul2981
5 pts.
Q:
Database being auto duplicate when exit.
Access 2007, Access Database, Microsoft Access
hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an auto duplicate database created e.g Database.mdb. Every time i have to delete the Database.mdb files to avoid user using the wrong database. please help me on solving this matter.

thanks 



Software/Hardware used:
MS Access 2007
ASKED: Nov 17 2009  7:23 AM GMT
James75
15 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
I got this problem too. I fixed it by turning off "Compact on Close" under Options >> Current Database. Not sure what to do if you want to keep this checked, though.

James
Last Answered: Jan 5 2010  2:19 PM GMT by James75   15 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _