[AccessD] A2003 to SQL: Write Conflict

Darren:

Do you have any Boolean fields? Because of the difference with the way
Access and SQL store the data, all Boolean fields must be non-nullable and
have a default value. If not, you will get the error you are reporting.
Check how the fields are defined in SQL Server. 

James Barash

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Tuesday, March 27, 2007 3:17 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A2003 to SQL: Write Conflict

Hi Eric - Stuart

Thanks for the quick response

I did have this issue last week and I was prompted to select a PK in a small
popup that would come during linking with a list of field names

So I now know to select the correct field and bat on

This allows me to add records into tables - cool


But I don't think this is it

But I have discovered that I can edit some fields in a new record - thus a
new
record gets created  but then say on the 4th or 5th field I edit I get the
error
message when I leave that field

So I can go into the tables and can see partly finished / partly edited
records
- this is a real pain in the butt

Help

Darren
------------------

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Tuesday, 27 March 2007 3:40 PM
To: Darren DICK
Subject: Re: [AccessD] A2003 to SQL: Write Conflict

You usually get this message when you have not identified the "unique 
key" when linking the tables which do not have a defined Primary Key.


On 27 Mar 2007 at 15:19, Darren DICK wrote:

> Hi All
> 
>  
> 
> I have set up a DSN to allow connections to an SQL dB - via an Access
front
end
> - cool
> 
>  
> 
> I connect to approx 20 tables
> 
>  
> 
> For the most part I can add/edit delete etc on those tables
> 
>  
> 
> But for some of those tables (the most important ones of course) each time
I
try
> to leave a field after making an edit I get the following error message
box
> 
>  
> 
> "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
> 
>  
> 
> Copying the changes to the clipboard will let you look at the value the
other
> 
> User entered, and then paste your changes back in if you decide to make
Changes"
> 
>  
> 
> Then there are 3 button at the bottom of this message box
> 
> <ButtonSAVERECORD=DISABLED>, <ButtonCOPY TO
> CLIPBOARD=Enabled>,<ButtonDROPCHANGES=Enabled>
> 
>  
> 
> Anyone know what I am doing wrong?
> 
>  
> 
> There are no other users - I have manually selected the tables in SQL
Server
and
> manually given my user name SELECT, INSERT,UPDATE and DELETE privileges
> 
>  
> 
> Signed - Desperate