By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Error adding a new detail record

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

<xa********@hotmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.