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 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
"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.
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.
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 -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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...
|
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...
|
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,...
| |