Corrupted Table 1

[pgwhalen]

We have a database that we use to track the work progress for several employees and initially it was discovered that the reports were no longer working for a certain job function. I have isolated the problem to one particular table.

I copied each table one by one into a blank database and each time I ran a Compile and Repair but as soon as I put this table into the new project, the compact bar goes only half way then stops and it just hangs there.

I do not see any corrupted data in the table itself. Is there any way out of this or is it square-one time?

Thanks!

 

[WildHare]

First off, make sure you have a backup of at least all the good stuff... then make another backup.

Some times a field in a table will get 'non-standard' bits stored in it through some freakish accident of nature. I had a record once in a field that had a non-printable high-order ASCII character stuck in it somehow and it made me nuts (recovery incomplete) trying to figure it out.

First, scroll through the entire raw table first, to see if that's possible. If this process blows up, you can be reasonably sure there's a dirty record in there someplace, and, should you wish to accept it, Mr. Phelps, your job is to track it down and terminate it with extreme prejudice, if you know what I mean.

Second, see if you can do a make-table query with all the fields and all the data to a new table. Then delete the old table and rename the newly made table.

There are other scenarios, but let us know how either or both of these work out.

Good Luck

PS - Remember, if your mission is compromised, the Director will disavow any knowledge of you.


78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[pgwhalen]

Thank you for the tip! I did indeed find some corrupted data in the table and all the fields in that record show squares instead of text. I tried to delete that record but am coming up with this error:

"The search key was not found in any record"

Click "OK" then:

"You cannot save this record at this time"

 

[WildHare]

Ok, you got a bum record. The reason you can't delete it is PROBABLY because Access lost the "next" and "previous" record pointers that go with him, so you can't delete him, because access won't know how to update the linked list.

Chances are any kind of procedural movement through that table will bomb when it hits this pothole.

Don't know how big your table is, but is Cut and paste an option?

You basically need to grab all the records on either side of this guy and stuff them in to the new table.

Good luck..keep us posted.. 78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[pgwhalen]

This definitely seems to be the way to fix it. I haven't completely fixed the whole database but tried a smaller scale fix in a blank database and it works great.

THANK YOU!!!! We are undergoing reviews and everyone's performance is in this table!!!

 

[montrose]

pgwhalen, This Microsoft Support question "ACC2000: How to Troubleshoot/Repair a Damaged Jet 4.0 Database (Q209137)" was related to another's post re: an error, but in looking at it, realized it might help you or others. Discusses exporting your info into an ascii file. (Thanks to I think it was Trudye?) May be worth looking at/saving for now or future use! Hope it helps, Montrose Learn what you can and share what you know.

 

[WildHare]

Just underscores the need for constant backups and checks of those backups....

Sounds like we got it nailed - good luck. PS if you should happen to find my employee review in there, please change the "disregards authority" to "maintains indifference to management." Thanks....
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm