Error adding a new detail record

Hi

I have a master/detail form with detail part being a sub form. My problem is
that when a user clicks on the sub form to add a record, this error comes
up; "The Microsoft jet database engine stopped the process.because you and
another user are attempting to change the same data at the same time.".

What is the reason for this error and how can I fix it?

Thanks

Regards

re: Error adding a new detail record

Hi John,

I've had that problem before when the data got corrupted. There had
been one record with #ERROR in one of the fields. Maybe there's a
better way, but I copied all the good records to a spreadsheet and then
recopied them to a new table. I don't know if that's the same as your
problem. You can also try deleting the .ldb file.

Miriam

re: Error adding a new detail record

OK. I'll try that. I have come across #error separately somewhere. My
solution is to give the user a button which does this;

1. Run a query to copy the currently displayed record into a temp table
minus the field with #error. Normally this is the memo field in the record.
2. Run a query to copy back the record into the main table.

Regards

<xangelbaby@hotmail.com> wrote in message
news:1114742199.772339.91080@l41g2000cwc.googlegro ups.com...[color=blue]
> Hi John,
>
> I've had that problem before when the data got corrupted. There had
> been one record with #ERROR in one of the fields. Maybe there's a
> better way, but I copied all the good records to a spreadsheet and then
> recopied them to a new table. I don't know if that's the same as your
> problem. You can also try deleting the .ldb file.
>
> Miriam
>[/color]