Write conflict for no reason at all :( ?

[joe789]

Hi Folks,

I got a strange issue: I am attempting to develop a Microsoft Access front end tied to a SQL Server back end via a linked table for a non-profit organization ... I have done a few of these programs before, but never ran into this problem I am having now.

If I try to enter a new record, it takes that record in just fine. If I go back and alter anything in that record, the form renders the following error:

Write Conflict:
This 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 .....

The interesting thing here is that I am the only one who is testing this program, no one else is in this program or table let alone this particular record. If I wait for an extended period of time, the error never goes away.

If I open the table directly instead of using the form, the error occurs the same way.

If I use a log on that has the highest rights possible for everything, this still occurs.

I can enter as many NEW records as I want, but try to alter a record that already exists and it throws that error out.

:banghead:

I tried everything I could think of ... please help


Thank you for any assistance you can provide,

Joe

 

[boblarson]

Does the table have a primary key field defined and, if so, has it been set to INTEGER? If not, it should be.

 

[Pat Hartman]

You are conflicting with yourself. Are you running update queries that will update the record you are viewing? Don't!