#error

[JACKSON]

Hi,

I have a database networked with about 8 users. We have been having a problem recently with a specific table. Occasionally, when a user opens a specific form based on this table the entire form is whitened out. When I open the database there is no major curruption, but then when I check the specific table I always find one record with "#Error" shown in every field. I cannot delete the record (invalid argument), so I compact & repair the database and the bad record changes all fields to "##########". Then I can delete the record and all is fine.

Any thoughts on what can cause this kind of error ?

Thanks

Jackson

 

[Len Boorman]

Sounds like it is a problem associated with not having a record locking strategy.

If two people have the same record open in for edit then there is a good chance that the record will be screwed.

On the properties of the form look for Record Locks. If the form is being opened such that the record can be edited then this should be set to Edited Record. This will prevent anybody else opening the recod in edit mode.

Record Locking is very important.

Len B

 

[JACKSON]

Thanks

Thanks, You gave me an idea.