[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
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.18/733 - Release Date: 25/03/2007
> 11:07 AM
>  
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.18/733 - Release Date: 25/03/2007
11:07 AM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.18/733 - Release Date: 25/03/2007
11:07 AM