Duplicate database problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I noticed that Access will duplicate databases on its own. From what my
colleagues tell me, this occurs whenever Access encounters an illegal
operation and has to be shut down. I need to solve this urgently as I can't
really scan the folder that often to look for duplicates which would result
in users entering data in different databases.

Rgrds,
blurz
 
This is not accurate - when a computer/server crashes, a backup of the
database is made under a different name; it is not likely that a user would
confuse the original database with a copy that has been generated to protect
it from further corruption.

Destin Richter
(e-mail address removed)
 
Hi,
My mistake. The duplicate database has a different name but it is close to
the original name. Is there a way to disable the duplicating function? If
not, is there a way to set the name of the duplicated database of my
preference?

Rgrds
 
blurz said:
Hi,
My mistake. The duplicate database has a different name but it is close to
the original name. Is there a way to disable the duplicating function? If
not, is there a way to set the name of the duplicated database of my
preference?

Rgrds

:
Click to expand...
I would take a different approach. Find out why it's crashing. I
run Access programs (some for years) and never had this problem. It's
either poorly designed code or if it's a hardware problem find out why.
Don't put a band-aid on it, get to the root of the problem.

gls858
 
Actually I'm not the one who wrote the program and I just have some basic
knowledge of Access. Most of the time I guess it's just a OS crash. But is
the duplicating of databases a built-in procedure of Access in event of
system errors/crashes or can it be configured?
 
blurz said:
Actually I'm not the one who wrote the program and I just have some basic
knowledge of Access. Most of the time I guess it's just a OS crash. But is
the duplicating of databases a built-in procedure of Access in event of
system errors/crashes or can it be configured?

:
Click to expand...
I afraid I don't have an answer for you on that. Post the version
of Access you have and maybe someone more knowledgeable can give you
an answer.

I did find an article about things that can effect your database.

http://support.microsoft.com/default.aspx?scid=kb;en-us;283849

Take a look at the section titled "Why .mdb files may become corrupted"
not exactly what you are experiencing but it might give you some ideas
of how to start tracking down the problem. If it a OS crash, which machine?
Why is it crashing. Your problem isn't that Access is making a duplicate
that's just a symptom, you need to find the real problem and your duplicates
will go away.
 
okok. WIll work on that. Thanks

gls858 said:
I afraid I don't have an answer for you on that. Post the version
of Access you have and maybe someone more knowledgeable can give you
an answer.

I did find an article about things that can effect your database.

http://support.microsoft.com/default.aspx?scid=kb;en-us;283849

Take a look at the section titled "Why .mdb files may become corrupted"
not exactly what you are experiencing but it might give you some ideas
of how to start tracking down the problem. If it a OS crash, which machine?
Why is it crashing. Your problem isn't that Access is making a duplicate
that's just a symptom, you need to find the real problem and your duplicates
will go away.
Click to expand...
 
Back
Top