473,396 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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 3152
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Paolo | last post by:
Hi, I am trying to compact and repair my database, however every time I try it comes up a message saying: Table: "TempMSysAccessObject already exists", whenever I try to look for this table I...
4
by: Ken Winters | last post by:
Whenever I run the Repair/Compact on my database, the security settings on the file change. A 3rd party application can only access the database over the network when the username "Everyone" is...
11
by: ritenah | last post by:
I am running this command from a .bat file. "C:\pathToAccess\MSACCESS.EXE" "C:\pathToDatabase\db.mdb" /REPAIR Database repairs as expected, then shows the messge: "Successfully repaired the...
3
by: G Gerard | last post by:
Hello The more I use an application ( an mdb) created using MSAccess I notice that the Byte size of the application keeps on increasing. Once in a while I do a Compact and Repair Database...
2
by: Ron | last post by:
Hi All, Using WinXP pro/Access 2000. I have a database that's been used for about 5 months. Transferred lots of data from a dos based program, then the users have been using it for that 5...
9
by: Ron | last post by:
New discovery. If I take a perfectly good database, and "compact/repair" on it with Access 2000 (seems to be at multiple sites--I've tried it with my system here, at another office on an...
2
by: RZ15 | last post by:
Hi, I was working on a query this morning and everything was working fine. Some time in the last half hour, I used the Compact & Repair Database feature. After that, when I went to open the query...
3
by: Bizmark | last post by:
Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL...
5
by: teddysnips | last post by:
My client has asked if it's possible to Compact and Repair his Front End database programmatically. I remember doing this from a VB application about 10 years ago, so I wondered if it was possible...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.