records can't be read

[charityg]

Here's my setup. Table on the network. Forms on the hard drive. Keep getting a message when scrolling one record to the next.
"Microsoft Jet database engine stopped the process because you and another user are trying to change the same data at the same time."
So I look to see who else is accessing the database on the network that contains the tables. NO ONE.
I click through the message about four times, and it always appears on records 44-48, but not any of the others.
Okay, so I compact the table database, but it stops with an error "Records can't be read; No read permission on...."
I HATE ACCESS!!!!! It's been behaving for about 3 months, but now it begins again. Does anyone have ANY clue what is happening. PLEASE HELP. I'm a proficient developer, but this is driving me nuts!!

 

[mrabrams]

This has happened to me a few times. It was due to "corrupt" records.
I was able to repair and compact using the JetComp utility. Then after the database is compacted, I go back into the table, the "corrupt" records now have #### across the entire row. I then delete these records, compact again and it is fine.

I have yet to have someone explain to my simple mind, what exactly is a corrupted record? The user types in the info the same way as always, but every so often a "corrupt" record appears.

Well, here is the link to the JetComp:
http://support.microsoft.com/support/kb/articles/q273/9/56.asp?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D24562%26redirect%3Dno

Good Luck!

Michael Abrams

 

[charityg]

Okay, maybe I'm overthinking, but why is the compact utility asking me for a user name and password? I can't get anything to work!