Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

a database copy is created automatically with a suffix added to the name

Status
Not open for further replies.

surotkin

Programmer
Dec 10, 2003
103
CA
Hello,
I have a database on a Shared LAN folder.
It has tables, queries, forms, reports, macros and modules - it is NOT split into back-end and front-end.
I found that a copy of the database is created by itself with suffix added to the database name periodically, ex. "MyDatabase[highlight #FCE94F]_9e64510d-3bce-4d43-9db9-4baf7accc236[/highlight].accdb"
Does anyone knows a reason it does that?

Thank you.
surotkin
 
Do you have your database set to compact on close?
Is there a good reason to not split the database?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Hi Duane,
No, Compact on Close is not set.

Yes, there is a reason the database is not split.
We inherited many databases.
The manager is not ready to make changes now.
I hope we will do it in the future.
As of now, the database will not be split for some time.

Thank you.
surotkin
 
Do all users have the ability to create and delete files in the folder containing the Access file?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top