The Data Has Been Changed Error

[sdbsadmin]

I have a SQL database with an Access front end that keeps giving me an error "The data has been changed... another user has edited the record..."

I'm the only user on it, and I'm trying to edit it directly from the table. I already checked my indexes and changed all the bits to ints (that caused a problem a different time), and I'm stuck.

Does anyone have any advice?

 

[MikeLeBen]

Why would you edit directly from the table?

Can you edit anything in the data?

Is the file read-only?

Do update/append queries work instead?

 

[sdbsadmin]

I really have a form to edit the data, but when I kept getting a message that I couldn't change the information, I tried directly editing the table to see if it was an issue with the form or an issue with the dataset.

Interestingly, some rows I can edit, although most I cannot. It's so perplexing, and I can't tell what makes one record different from another. Most are not editable.

No, the file is not read-only.

Update/append queries do work, as does inserting a new record. It's only updating the table manually or within a form that doesn't work.

Thank you so much for your help!

 

[sdbsadmin]

Never mind... I figured out what it was. I have an update query running every few seconds, and I didn't realize that it was changing the data in a way that would lock it. Thanks for the help.

 

[MikeLeBen]

Mh, then I'm curious as to what the settings in your table structure are, and if you're using special kind of fields.

 

[MikeLeBen]

oh, glad you solved it then

 

[sdbsadmin]

Me too. Thanks for the help! I'm going to set the bits back to bits (not ints) and make sure it still works.... SQL is so much more complicated than Access.