I have a slight problem with a database table, this is the third time in a week that this has happened and I can not see why.

1 record in the table appears to become corrupt, #ERROR appears in every field (15 fields in table, 1 autonumber, 4 number, rest text, 6000 records total)

every time you try to use this table after this record currupts (different record ID each time), you receive an error which just says 'Invalid Argument'.

I have run a repair on the database and have recreated the table from scratch but it still happens.

I have searched the MS KB but found the causes listed there are not what is causing this, the database is already split (one of theie solutions to this) and no make table or append queries are being run. I'm out of ideas!

Has anyone came across this before or have any clues to what may cause this?

Are you running any code?

one of my users got a corrupted database, which manifested as 2 rows of odd values in 1 table. Allow access shows to us mortals as tables queries etc, it is obviously stored in a completely different way. Can you delete the bad record manually. This might clear up the problem.

here is the code behind the form

Private Sub Command27_Click()

If IsNull(Me.DelDate) Then
DSPMSG "You must enter a delivery date"
Me.DelDate.SetFocus
Exit Sub
End If

If Me.CustCode < 1 Then
DSPMSG "You must enter a customer"
Me.CustCode.SetFocus
Exit Sub
End If

End Sub

Private Sub Command32_Click()

Me.Status = "Loaded"
Forms!frmGoodsOut.Refresh

End Sub



Nothing in there that would cause any corruptions as far as I can see.

I can not delete the bad record from the table which is why I have recreated the table from scratch. Once this record becomes corrupt you can not perform any functions on the table as it will only produce the 'Invalid Argument' error.

I suspect that you have no record locking strategy in place. I have seen this situation occur where as a result of no locking strategy #Error appears in all fields of a row.

You will also find that you are unable to delete that particular row.

If what I have said applies to your situation then what is happening is that more than one user is attempting to add/edit the same record

On the properties of the Add and Edit Forms find record locking. If it says No Locks then that is your problem. Change it to Edited record

Record locking strategy is very important.

Len

Thanks Len

it was set to no locks, this has been changed and hopefully this will not happen again.