[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Access creating additional database files upon close

Posted on 2011-09-07
Medium Priority
Last Modified: 2012-05-12
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:
...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.
Question by:jbarnette
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2

Accepted Solution

BusyMama earned 100 total points
ID: 36498680
I can't guarantee this is your cause, but I have seen similar issues in the past when a database compact and repair is interrupted or for some other reason not completed.  I have always deleted them without issue.  You can try opening them to see if there's anything lurking in there .... :)

Author Comment

ID: 36498785
Thanks for the reply. The problem that occurred was that I had up to 5 people in there at one time and somehow up to 12 database.mdb files were created. Then some other folks came and entered information into the mdb files instead of the accdb file. Now i have some info in the main database, and other info in these ghost databases that were created and it's become a nightmare. I basically deleted the mdb files and told them to reenter the information; however i need to find out how to prevent this in the future. I've also heard of the compacting issue, but there was no compacting with this database during these occurrences.
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye earned 100 total points
ID: 36498825
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.

You can tell whether anyone is in any of these databases by checking for the .ldb or .laccdb file associated with the mdb or accdb.  If the lock file doesn't exist, it is OK to delete the datafile.  

I don't envy you having to check all of those databases for data that was entered into the wrong mdb file.
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.


Author Comment

ID: 36498903
I understand...but is there a way to prevent these additional database files from being created?

Author Comment

ID: 36502878
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.

LVL 48

Expert Comment

by:Dale Fye
ID: 36503411
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.

Author Closing Comment

ID: 36503455
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.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question