New Access user!

50 pts.
Tags:
Access Database
Microsoft Access
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there's about 12 -15 copies. ( Example: mdb12 ) Is there a way to stop this? Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check if the file is read only, if it was remove it

/////////////////////////////////////
This generally happens when someone opens Access to create a new database but doesn’t name it.
So the system is forced to name it different from any existing database file.

Phil

___________________________________________

Tami
Are you saying that these files contain a copy of the data or are they blank databases?
Phil

Phil.

These files contain a copy of the data.

Tami

____________________________________________
Tami

It sounds like the tools-database utiltiies backup database or compress database is being run
but I cannot find a setting to make that automatic — part of a macro or VB script perhaps.
Could be part of the database startup or form?

Phil

Hello all:
I was out of town for about 2 weeks & intentionally did not connect to this site!!!
Now I am noticing nice questions and answers. I will spend some time to answer some of the queries – that I feel comfortable to lend support.
On this question – I am assuming this is related to Access 2007. Since it is on a shared drive – the system administrators may have set a code to take a backup as database is changed on User exit. Also there are options to log all changes. May be the changes are really log files. So the options to investigate will be to:
1) Check with system administrators if they have set up to take automatic back up on exit.
2) Check the database mdb12 – is this is a complete database? In other words what is the difference between mdb11 and mdb12?
3) As for compressing the database – I highly recommend it (Access database gets too much bloated with normal use. In Access 2007: 1) Click on the Office Button 2) Click Access Options (bottom right) 3) Click Current Database (from list on left side) 4) Check “Compact on Close”.
Note: after typing this message – I noticed that this is more likely related to Access 2003 – since this is a mdb file.
SbElectric

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tami85
    No it is not read only. Any other ideas? Thanks for your input!
    50 pointsBadges:
    report
  • Tami85
    Phil, Let me explain the situation.....A database file has been created for our Manufacturing Plant. Each Department Manager will access the file through a network drive. Each Dept Head adds Production and Breakdowns, etc for their Department. Each time an individual finishes adding to the database & they close out, the information is saved......but it also creates a copy and names it db1.mdb, and it is always 820 KB in size. ( Regardless if the original file is larger ) I don't understand what is happening here. Do you? Any help you can provide would be greatly appreciated. Tami
    50 pointsBadges:
    report
  • Tami85
    Phil. These files contain a copy of the data. Tami
    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following