jbarnette
asked on
Access creating additional database files upon close
I searched but couldn't find the answer i was looking for. I have an Access database that multiple people use shared from a server. I've noticed lately that in the same folder as this database, there are other multiple databases named such:
Database1.mdb
Database2.mdb
Database3.mdb
...and so forth.
Could anyone tell me why Access is creating these files, how to stop it, and if it is safe to delete them? Also, i have Compact on Close disabled for this database.
Thank you.
Database1.mdb
Database2.mdb
Database3.mdb
...and so forth.
Could anyone tell me why Access is creating these files, how to stop it, and if it is safe to delete them? Also, i have Compact on Close disabled for this database.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I understand...but is there a way to prevent these additional database files from being created?
ASKER
You should NEVER tell people where your application or the data is sitting on your server. They should all have their own front-ends on their PCs, which point to the backend data sitting on your server.
Ok. so i split the database. Now i have a front end with all the forms, reports and such and it is distributed to the desktop of each person's workstation via a logon script. This front end database has linked tables to the backend database. Is this what you are suggesting? Did i do it correctly and do you think this will resolve my issue?
Thank you.
The login script is a great way to put the latest version of the application on their desktops. There are other methods, but that one generally works well.
As BusyMama stated the problem with the additional databases is generally created by a unsuccessful compact/repair operation. Since you are redeploying the front-end each time your users log on, I'd make sure that the Compact On Close setting of the Front-end is set to No. This should hopefully resolve the issue of the duplicate Database#.mdb files.
The other problem you are likely to have is that you have users that are familiar with where the application used to reside, so you may still encounter problems with them going directly to that folder on the server and attempting to open the database from there.
As BusyMama stated the problem with the additional databases is generally created by a unsuccessful compact/repair operation. Since you are redeploying the front-end each time your users log on, I'd make sure that the Compact On Close setting of the Front-end is set to No. This should hopefully resolve the issue of the duplicate Database#.mdb files.
The other problem you are likely to have is that you have users that are familiar with where the application used to reside, so you may still encounter problems with them going directly to that folder on the server and attempting to open the database from there.
ASKER
Thanks for the great tips! I'm going to ensure the compact on close is disabled on the front end application and we'll see how it goes.
Thanks!
Thanks!
ASKER