Table Damaged

[Roy Goldhammer]

Well Eric

The problem i solved by removing these bad lines and set the primary key
back

The question is: how this thing can happen?

After more test i thing i know what cause it:

On my applicaion on sunday I send some of my data to archive files.

this process happen when the last user on the system close the application.

He probebly close it by shutting down the computer and therefore the
computer shut down while the transfare was in progress.

Can something like this cause this error?

and if it can is there better way to run some quries on praticular day?

Hope that you can help me

 

[Roy Goldhammer]

Thankes John

But this think can happen if you give an order in the windows to shut down.
Windows XP terminate every action that don't being closed in 15 seconds (it
considerd it as program that stuck) so this thing could cause the
corruption. Is there way to tell the windows that the program is in progress
and not stuck?

Or can I do the archive in a diffrent way?

Hope that you can help me

 

[Roy Goldhammer]

Hello there

One of my tables suddenly got 60 rows of ### inside of it and the primary
key has lost.

What can cause this error?

 

[Eric Butts [MSFT]]

Hi Roy,

Corruption. Either use Compact/Repair or JetComp.exe, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| From: "Roy Goldhammer" <[email protected]>
| Subject: Table Damaged
| Date: Wed, 14 Apr 2004 13:46:19 +0200
| Lines: 8
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: dsl217-132-25-53.bb.netvision.net.il 217.132.25.53
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:78329
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hello there
|
| One of my tables suddenly got 60 rows of ### inside of it and the primary
| key has lost.
|
| What can cause this error?
|
|
|

 

[John Vinson]

He probebly close it by shutting down the computer and therefore the
computer shut down while the transfare was in progress.

Can something like this cause this error?

Very reliably. This is almost certain to corrupt databases; the user
should be taken aside and you should carefully explain that this is
very much like shutting off the ignition while traveling at 110 km/hr
on (busy crowded highway of your choice) and asked to NEVER do it
again.

 

[John Vinson]

Thankes John

But this think can happen if you give an order in the windows to shut down.
Windows XP terminate every action that don't being closed in 15 seconds (it
considerd it as program that stuck) so this thing could cause the
corruption. Is there way to tell the windows that the program is in progress
and not stuck?

In my experience, Windows does NOT shut down Access if a query runs
long. If the user attempts to interrupt Access, WinXP will pop up a
message saying that the program is not responding (and the time delay
is adjustable, though I cannot remember at the moment just how); but
the user can - and should - select the option to let the program
continue.