Tonight I had a corrupt database which Access was able to repair after I
made my backup. The database seems to be working well again. How certain can
I be that the database is repaired well and doesn't have any hidden errors
still inside. Should I take some other precautions? Should I rebuild the app
beforehand by importing the tables, reports etc in another databse?
Thanks for any advice.
john 3 1412
The database is probably okay.
Look in the list of tables for any new tables. If you see a name such as
Microsoft Repair Error, read the table to see what it says. You may find
that a bad record was deleted, or an index was dropped. Check the
Relationships diagram (Tools menu) to ensure each table's primary key is in
place and all relationships still exist.
Importing everything into a new app, while not essential, does force Access
to read all the objects from the database. So if there was a problem with
reading an object, it would show up by doing that. Before you do, I suggest
you decompile the app, and ensure that Name AutoCorrect is turned off in the
new app before importing. Then eliminate all references you don't need, and
check that it compiles.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John" <jo@hn.comwro te in message news:er******** *@textnews.wana doo.nl...
Tonight I had a corrupt database which Access was able to repair after I
made my backup. The database seems to be working well again. How certain
can I be that the database is repaired well and doesn't have any hidden
errors still inside. Should I take some other precautions? Should I
rebuild the app beforehand by importing the tables, reports etc in another
databse?
Thanks for any advice.
john
"Allen Browne" <Al*********@Se eSig.Invalidwro te in
news:45******** **************@ per-qv1-newsreader-01.iinet.net.au :
Importing everything into a new app, while not essential, does
force Access to read all the objects from the database. So if
there was a problem with reading an object, it would show up by
doing that. Before you do, I suggest you decompile the app, and
ensure that Name AutoCorrect is turned off in the new app before
importing. Then eliminate all references you don't need, and check
that it compiles.
A decompile is only relevant if it's a front-end. Back ends, with
tables only, don't usually have any code in them to be decompiled.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Thanks Allen,
No new tables appeared and no links disappeared, so I'm not going into the
hassle of importing into a new database. Thanks for the info.
john
"Allen Browne" <Al*********@Se eSig.Invalidsch reef in bericht
news:45******** **************@ per-qv1-newsreader-01.iinet.net.au ...
The database is probably okay.
Look in the list of tables for any new tables. If you see a name such as
Microsoft Repair Error, read the table to see what it says. You may find
that a bad record was deleted, or an index was dropped. Check the
Relationships diagram (Tools menu) to ensure each table's primary key is
in place and all relationships still exist.
Importing everything into a new app, while not essential, does force
Access to read all the objects from the database. So if there was a
problem with reading an object, it would show up by doing that. Before you
do, I suggest you decompile the app, and ensure that Name AutoCorrect is
turned off in the new app before importing. Then eliminate all references
you don't need, and check that it compiles.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John" <jo@hn.comwro te in message
news:er******** *@textnews.wana doo.nl...
>Tonight I had a corrupt database which Access was able to repair after I made my backup. The database seems to be working well again. How certain can I be that the database is repaired well and doesn't have any hidden errors still inside. Should I take some other precautions? Should I rebuild the app beforehand by importing the tables, reports etc in another databse? Thanks for any advice. john
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Roeland |
last post by:
Hello,
I added in my (MSI) installer project an advertisable shortcut, that
automatically repairs the installation when something is corrupted. It would
be more fine to have a normal shortcut, but I understood that this is not
possible without using Orca.
My installation project contains a custom action to start the application
after installation. However, now when I start the application with the
advertisable shortcut (and there is...
|
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 cannot find it anywhere... Any
clues...
Already went into the help file and nothing...
Also try to copy my database and the same message comes up
|
by: Microsoft |
last post by:
Hi,
Here is the problem that Iam experiencing, does anyone has a
suggestion/solution ??
I use C# .NET Deployment project to install my application, which
installs few windows Services. The following are the sequence of steps to
simulate the problem
1) INSTALL the Application by clicking the setup.exe. Because the
|
by: Peteroid |
last post by:
Recently, and for reasons I don't know, the project I was working on started
to compile either very slowly, or it was locking up.
So, I repaired VS C++.NET 2005 Express via 're-installing' it without first
removing it. The repair worked, and the project now compiles in a timely
manner.
My question is this. After the offer to download the Express versions for
free has expired (Nov 2006), will some means to repair the ones we have...
|
by: Programatix |
last post by:
Hi,
I'm trying to distribute my application written using .NET Framework 2.0. It
uses a MDB file for it's database.
On certain machines with Windows XP (I have also tried updating them to
SP2), I received this exception when the application tries to connect to the
MDB
"The .Net Framework Data Providers require Microsoft Data Access Components
| |
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 ..." and you have to click "Ok" to get rid
of the message so that the database can close.
How does one suppress this message, so that the database shuts down
|
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
months. About 180000 records in one of the main files (maybe 25000 new since
the dos conversion). Been having some speed issues crop up along the way
(much faster to do same reports when I first transferred the data than now,
with the new 25000...
|
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 entirely different network), it damages the file
somehow. The user's machine that did the compact/repair can see the file
fine. But any networked user can't get in. I can double click on a good
database file from any user (over the network) and it...
|
by: zufie |
last post by:
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
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |