Write Conflict

[shafiee]

Hi there,

I have two tables which has a one-to-one relationship between them. I
created a view combining the fields of both tables, and when trying to add a
new record in that view, I'm getting the following error:

---------------------------------------------------------------------
Write Conflict
? X
---------------------------------------------------------------------
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.

Copying the changes to the clipboard will let you look at the values
the other user entered, and then paste your changes back in if you
decide to make changes.

[Save Record] [Copy to Clipboard] [Drop Changes]
---------------------------------------------------------------------

When I click Save Record button, I'm getting the same error again. When I
click Drop Changes, records are added to one table, but the records for the
other table is dropped.

Can anyone help me?

Shafiee.

 

[Vadim Rapp]

Hello shafiee,
You wrote in conference microsoft.public.access.adp.sqlserver on Sun, 29
May 2005 10:49:23 +0500:

s> I have two tables which has a one-to-one relationship between them. I
s> created a view combining the fields of both tables, and when trying to
s> add a new record in that view, I'm getting the following error:

s> ---------------------------------------------------------------------
s> Write Conflict
s> ? X

are there any triggers on either of the tables?


Vadim Rapp

 

[shafiee]

Hi Vadim,

There aren't any triggers for either tables.
Should I be using triggers?

Shafiee.

 

[shafiee]

Oh I got it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;241717

It was a bug. I have to download the latest service pack for SQL server.

Can anyone tell me how to get it?

Shafiee.

 

[Sylvain Lafontaine]

Sure, for SQL-2000:
http://www.microsoft.com/sql/downloads/default.mspx

and fro SQl-7:
http://www.microsoft.com/sql/downloads/servicepacks.mspx

However, I'm not sure if your problem is related to a lack of the latest
service pack. Many things can lead to a write conflict under ADP. Take a
look at the previous post in this newsgroup and you will find many
suggestions. (If necessary, Google has a full archive of them. See:
http://groups.google.ca/group/microsoft.public.access.adp.sqlserver )

One of the best suggestion is to use the Profiler on the SQL-Server to see
what Access is doing.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Oh I got it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;241717

It was a bug. I have to download the latest service pack for SQL server.

Can anyone tell me how to get it?

Shafiee.

Hi there,

I have two tables which has a one-to-one relationship between them. I
created a view combining the fields of both tables, and when trying to
add a new record in that view, I'm getting the following error:

---------------------------------------------------------------------
Write Conflict ? X
---------------------------------------------------------------------
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.

Copying the changes to the clipboard will let you look at the values
the other user entered, and then paste your changes back in if you
decide to make changes.

[Save Record] [Copy to Clipboard] [Drop Changes]
---------------------------------------------------------------------

When I click Save Record button, I'm getting the same error again. When I
click Drop Changes, records are added to one table, but the records for
the other table is dropped.

Can anyone help me?

Shafiee.

 

[Vadim Rapp]

Hello shafiee,
You wrote in conference microsoft.public.access.adp.sqlserver on Sun, 29
May 2005 12:31:16 +0500:

s> There aren't any triggers for either tables.
s> Should I be using triggers?

No. I asked because triggers could produce this effect.

I would run Profiler on sql server to see what's going on. Also, do both
tables have primary keys?

Vadim

 

[shafiee]

I'm pretty sure that no triggers are involved, because the database was very
badly designed at first. I was the one who created the relationships to work
with queries. The problem I had was data entry, as the designer didn't
provide a simple location from which data can be entered. There were
unrelated data everywhere, because of the data entry problem. I had to use a
delete query to delete the unrelated data, and now relationships control how
data is entered... i mean unrelated data cannot be entered now.

Actually the db collects information about staff in two different tables -
StaffNames and StaffContacts. StaffNames have the primary key, StaffContacts
have the foreign key. Earlier there was no relationship between StaffNames
and StaffContacts. But now, I have created a one-to-one relationship.

Although I didn't solve the actual problem, I followed a recommendation of
microsoft which employs subforms in adp which made life a whole lot easier.

But I would really like to know if there is a solution to the actual
problem.

Shafiee.

 

[Vadim Rapp]

Hello shafiee,
You wrote in conference microsoft.public.access.adp.sqlserver on Sun, 29
May 2005 12:58:07 +0500:

s> Oh I got it.
s> http://support.microsoft.com/default.aspx?scid=kb;en-us;241717

s> It was a bug. I have to download the latest service pack for SQL server.

hmm... the message in the article has nothing in common with yours... it
even comes from sql server, while yours comes from Access.


Vadim

 

[shafiee]

Yeah... the same view cannot be edited in enterprise manager.
The bug exists in both access and SQL server i guess.