Write Conflict in Query

[lorirobn]

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?

[deluxeinformation]

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