Yikes! Error in table....

[marydoyle9]

Can someone help me please... have a database, users enter/update the data using forms. I had two users that tried to update at the same time. Two of the fields show "#Error" in them and when you try to access this recird you get a message "The
Microsoft Jet database engine stopped because you and another user are attempting to change the same data at the same time".

How do I fix this? I tried to go into the table and that doesn't work. Tried an update query and that doesn't work either. Oh - one more thing... after a few tries, I get a message saying Access encounters errors and a log is being written and Access is shutting down. Then *poof* - it closes. Where the heck is this log file?

I am not an Access programmer so gotta keep this simple...

Thanks!
Mary

If you need, I can send a printscreen of the errors.... let me knwo. Thx.

 

[MikeAngelastro]

Hi Pat,

Do you have any ideas about how to isolate the bad record? I have a back-end database that may be corrupt but I'm not sure. I tried using DTS in SQL Server thinking that SQL Server would refuse to import a bad record. I finally figured out that the records that DTS had errors with were records with date fields with data out of the range allowed by SQL Server. Access is too tolarant when it comes to certain things. As far as you know, is DTS a useful tool for isolating corrupt records?

Thanks,

Mike