How do you deal with a corrupt table?

[aualias]

I have been presented with a database that seems to be corrupt. It seems
that certain rows cause query errors. A dialog with "Invalid Argument" pops
up. For example the following query is ok:

SELECT top 7901 [Transaction ID]
FROM [Foreclosure Stage 1]
where IsDate([File Closed Date])

However if I change it to top 7902, I get the error.
Also, if I try to repair and compact the database Access crashes every time.
I tried import the table involved, but got the Invalid Argument dialog and
the import failed.

I am using Access 2003. I am trying to find out the version of the original
application, but do not know as of now. I used the /decompile switch to
start the application, but is did not seem to do anything (does it work on
2003?)

Any suggestions would be appreciated. Thanks.

David

 

[Jeff Conrad]

in message:

I have been presented with a database that seems to be corrupt. It seems
that certain rows cause query errors. A dialog with "Invalid Argument" pops
up. For example the following query is ok:

SELECT top 7901 [Transaction ID]
FROM [Foreclosure Stage 1]
where IsDate([File Closed Date])

However if I change it to top 7902, I get the error.
Also, if I try to repair and compact the database Access crashes every time.
I tried import the table involved, but got the Invalid Argument dialog and
the import failed.

I am using Access 2003. I am trying to find out the version of the original
application, but do not know as of now. I used the /decompile switch to
start the application, but is did not seem to do anything (does it work on
2003?)

See if these links on corruption help.

http://allenbrowne.com.au/ser-47.html

http://www.granite.ab.ca/access/corruptmdbs.htm

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
(See Fix Corrupt Access Database v3.9 Document)

http://www.e-tech.ca/001-AccessFAQ.asp

http://www.everythingaccess.com/tutorials.asp?ID=0

ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
http://support.microsoft.com/?id=815280

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?id=306204

ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137

ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771

ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=304561

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

Good luck,

 

[aualias]

Jeff,

Thanks for the links.

David

in message:

I have been presented with a database that seems to be corrupt. It seems
that certain rows cause query errors. A dialog with "Invalid Argument"
pops
up. For example the following query is ok:

SELECT top 7901 [Transaction ID]
FROM [Foreclosure Stage 1]
where IsDate([File Closed Date])

However if I change it to top 7902, I get the error.
Also, if I try to repair and compact the database Access crashes every
time.
I tried import the table involved, but got the Invalid Argument dialog
and
the import failed.

I am using Access 2003. I am trying to find out the version of the
original
application, but do not know as of now. I used the /decompile switch to
start the application, but is did not seem to do anything (does it work
on
2003?)

See if these links on corruption help.

http://allenbrowne.com.au/ser-47.html

http://www.granite.ab.ca/access/corruptmdbs.htm

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
(See Fix Corrupt Access Database v3.9 Document)

http://www.e-tech.ca/001-AccessFAQ.asp

http://www.everythingaccess.com/tutorials.asp?ID=0

ACC2000: How to Recover Data from a Corrupted Table by Using the DAO
Method
http://support.microsoft.com/?id=815280

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?id=306204

ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137

ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771

ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0
Database
http://support.microsoft.com/?id=304561

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

Good luck,

 

[Jeff Conrad]

in message:

Jeff,

Thanks for the links.

David

You're welcome, I hope you get the problem fixed.