You and another user attempting to change data....

[lorirobn]

Hi,

I am getting the error "The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time." It happens when I try to delete one row from a table.

This is my scenario. I am testing a certain situation, so I use a form to add a record, then I go into the table via a query, and select the row to delete it. When I do so, I get the above message. I could have sworn that it let me do the delete earlier today. But I have been getting this message on and off during my testing today.

I am the only user, so I know no other user is locking the record. Could I have locked it when I did an Insert from my form? I have read lots of threads regarding this error, but none seem to apply. I did a compact and repair of the db, but it did not help. I exited Access and got back in, but still no good. All else seems to work fine, except the delete of this one record.

I am running SQL server on my laptop (MSDE), with linked tables, from front end to back end.

Any suggestions?

Thanks,
Lori

 

[PHV]

Have you a TimeStamp field in the MSDE linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lorirobn]

No, PH, I don't have a TimeStamp field. Should I?

 

[FancyPrairie]

Is one of your fields in the SQL database declared as a bit? If so, does it allow for nulls? Bits should can not contain nulls...Set the default property to 0 or something.

 

[lorirobn]

OH!!!!
When I was running into Insert problems recently, I changed 'allow nulls' to Yes on my bit fields!!
Soooo.... I am changing them back, and hopefully this will do the trick.
Thank you so much, FancyPrairie! You have helped me once again.

Lori

 

[lorirobn]

PS - I'm also curious - are these checkbox fields (which is how I have the 'bit' field set up in Access) the standard and accepted way to set up a Yes/No field? Or do folks generally set them up as text fields with 'Y/N' values, so they are more flexible (and avoid problems such as this one).
thanks... Lori

 

[PHV]

The standard setup is a BOOLEAN field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886