470,614 Members | 1,425 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Repair/Compact Database

When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...

How else may I repair this database?

Thanks!,

Zuf
Feb 20 '08 #1
4 2991
Hi Zuf,

If you open the database you wish to compact & repair, then it won't prompt
you to save it with a new file name.

When you compact & Repair a closed database, it always prompts you to save
with a new file name.
However, you can name it the same as the original file and choose to
overwrite the original.

Andy

zufie wrote:
>When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...

How else may I repair this database?

Thanks!,

Zuf
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200802/1

Feb 20 '08 #2

"zufie" <jo***********@illinois.govwrote in message
news:28**********************************@41g2000h sc.googlegroups.com...
When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...

How else may I repair this database?

Thanks!,

Zuf
IMHO a copy of the database during a Repair/Compact is a good thing.If you
have an crash during a Repair/Compact to the same file, the MDB can be
corrupted beyond repair.My process is to rename the original the
Repair/Compact to the original file name.
Feb 20 '08 #3

On Feb 20, 12:10*pm, "paii, Ron" <n...@no.comwrote:
"zufie" <john.marru...@illinois.govwrote in message

news:28**********************************@41g2000h sc.googlegroups.com...
When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...
How else may I repair this database?
Thanks!,
Zuf

IMHO a copy of the database during a Repair/Compact is a good thing.If you
have an crash during a Repair/Compact to the same file, the MDB can be
corrupted beyond repair.My process is to rename the original the
Repair/Compact to the original file name.
Feb 20 '08 #4

On Feb 20, 1:18*pm, Greg <CodeBo...@gmail.comwrote:
On Feb 20, 12:10*pm, "paii, Ron" <n...@no.comwrote:
"zufie" <john.marru...@illinois.govwrote in message
news:28**********************************@41g2000h sc.googlegroups.com...
When I Repair/Compact my Access databse. I get icons/copies of a
database named db1.mdb, db2.mdb, db3.mdb, etc...
How else may I repair this database?
Thanks!,
Zuf
IMHO a copy of the database during a Repair/Compact is a good thing.If you
have an crash during a Repair/Compact to the same file, the MDB can be
corrupted beyond repair.My process is to rename the original the
Repair/Compact to the original file name.- Hide quoted text -

- Show quoted text -
Feb 20 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by G Gerard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.