[AccessD] A2003 to SQL: Write Conflict

Make sure all SQL tables have a primary index.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Monday, March 26, 2007 10:19 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003 to SQL: Write Conflict

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: 3/25/2007
11:07 AM