Auto Creation of "_Backup.mdb"

I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find a file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to do this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.

You may have the database set to compact on close. Access creates a file
named "yourdatabase_Backup.mdb" and then deletes it when the compact has
completed. If the compact fails for some reason, the backup file is not
deleted.

"Access101" wrote in message
...
I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find a
file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to do
this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.

Pat, thanks for your quick response.

I don't see that option checked on my machine, but I haven't yet checked the
other user's setting.

Is it a setting particular to the db itself, or per the individuals choices
in their own Access application?

"Pat Hartman (MVP)" wrote:

You may have the database set to compact on close. Access creates a file
named "yourdatabase_Backup.mdb" and then deletes it when the compact has
completed. If the compact fails for some reason, the backup file is not
deleted.

"Access101" wrote in message
...
I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find a
file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to do
this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.

The setting is specific to the database. This could also happen if the user
manually selected to compact/repair the database.

"Access101" wrote in message
...
Pat, thanks for your quick response.

I don't see that option checked on my machine, but I haven't yet checked
the
other user's setting.

Is it a setting particular to the db itself, or per the individuals
choices
in their own Access application?

"Pat Hartman (MVP)" wrote:

You may have the database set to compact on close. Access creates a file
named "yourdatabase_Backup.mdb" and then deletes it when the compact has
completed. If the compact fails for some reason, the backup file is not
deleted.

"Access101" wrote in message
...
I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find a
file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to do
this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.

Any other ideas then?

There's no way she's compacting or doing anything other than asking how do
you even open a database.

Thanks,
Michael


"Pat Hartman (MVP)" wrote:

The setting is specific to the database. This could also happen if the user
manually selected to compact/repair the database.

"Access101" wrote in message
...
Pat, thanks for your quick response.

I don't see that option checked on my machine, but I haven't yet checked
the
other user's setting.

Is it a setting particular to the db itself, or per the individuals
choices
in their own Access application?

"Pat Hartman (MVP)" wrote:

You may have the database set to compact on close. Access creates a file
named "yourdatabase_Backup.mdb" and then deletes it when the compact has
completed. If the compact fails for some reason, the backup file is not
deleted.

"Access101" wrote in message
...
I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find a
file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to do
this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.

Nope, the file in question is left by a failed backup.

"Access101" wrote in message
news
Any other ideas then?

There's no way she's compacting or doing anything other than asking how do
you even open a database.

Thanks,
Michael


"Pat Hartman (MVP)" wrote:

The setting is specific to the database. This could also happen if the
user
manually selected to compact/repair the database.

"Access101" wrote in message
...
Pat, thanks for your quick response.

I don't see that option checked on my machine, but I haven't yet
checked
the
other user's setting.

Is it a setting particular to the db itself, or per the individuals
choices
in their own Access application?

"Pat Hartman (MVP)" wrote:

You may have the database set to compact on close. Access creates a
file
named "yourdatabase_Backup.mdb" and then deletes it when the compact
has
completed. If the compact fails for some reason, the backup file is
not
deleted.

"Access101" wrote in message
...
I'm working in Access 2002 (mistkae number 1, I know).

But recently, when a user opens a database called DbName.mdb, I find
a
file
file called DbName_Backup.mdb in the directory soon thereafter.

I delete the backup, but later it appears again. It doesn't seem to
do
this
when I open the db. Any enlightenment is appreciated. I've
compacted/repaired, etc. No corruption notices.