By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,912 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.

Write Conflict in Query

P: n/a
Hi,

I have a query that I have been using as a record source for a form
with no problems. I just created a new "addnew" form, and added 20
records to the table with this form. The problem I now have is I
cannot modify data on these new records using my query.

The query's sql is: SELECT tblSpaceUse.* FROM tblSpaceUse;
The error I get is:
"Write Conflict -
The record has been changed by another user since you started editing
it. If you save the record, you will overwrite the changes the other
user made."

I thought maybe the "*" in the sql had something to do with it, so I
listed each field individually instead.
(SELECT tblSpaceUse.RoomID, tblSpaceUse.RoomLocation,
tblSpaceUse.FloorNumber
FROM tblSpaceUse;)
However, I get inconsistent results. Sometimes I can change the data,
sometimes I still get Write Conflict. But it's weird: one time, I
changed a value from 2 to 3, 3 to 4, 4 to 5, and it was fine, but then
I changed it to 6, and I got the write conflict. But when I tried the
same sequence again, it behaved differently. (all these values are
valid.)

I am able to change older records with either statement!!

I don't know if it's how I'm adding, or something on my table. I
compared new records with old, and I can't see anything that's
different.

Any suggestions?

Thanks in advance.
ps - is there a way to get notified when I have a response on this
thread?

Sep 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

lorirobn wrote:
Hi,

I have a query that I have been using as a record source for a form
with no problems. I just created a new "addnew" form, and added 20
records to the table with this form. The problem I now have is I
cannot modify data on these new records using my query.

The query's sql is: SELECT tblSpaceUse.* FROM tblSpaceUse;
The error I get is:
"Write Conflict -
The record has been changed by another user since you started editing
it. If you save the record, you will overwrite the changes the other
user made."

I thought maybe the "*" in the sql had something to do with it, so I
listed each field individually instead.
(SELECT tblSpaceUse.RoomID, tblSpaceUse.RoomLocation,
tblSpaceUse.FloorNumber
FROM tblSpaceUse;)
However, I get inconsistent results. Sometimes I can change the data,
sometimes I still get Write Conflict. But it's weird: one time, I
changed a value from 2 to 3, 3 to 4, 4 to 5, and it was fine, but then
I changed it to 6, and I got the write conflict. But when I tried the
same sequence again, it behaved differently. (all these values are
valid.)

I am able to change older records with either statement!!

I don't know if it's how I'm adding, or something on my table. I
compared new records with old, and I can't see anything that's
different.

Any suggestions?
Why not simply use the table itself as the recordsource for your forms?
"SELECT * FROM <tablename>" without any limiting criteria (e.g. a
"where" clause) is equivalent to simply using the table itself.
Thanks in advance.
ps - is there a way to get notified when I have a response on this
thread?
Don't know about that one. Perhaps there is a setting in your
newsreader software.

Bruce

Sep 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.