Write Conflict

  • Thread starter Thread starter shafiee
  • Start date Start date
S

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.
 
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
 
Hi Vadim,

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

Shafiee.
 
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


shafiee said:
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.

shafiee said:
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.
Click to expand...
Click to expand...
 
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
 
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.
 
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
 
Yeah... the same view cannot be edited in enterprise manager.
The bug exists in both access and SQL server i guess.
 
Back
Top