By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Write conflict on SQL 2000 ODBC linked table

P: n/a
Hello,

I have an Access 2002 front end that is connected to an SQL Server 2000 back
end. The ODBC links connected to the front end are DSNless and have
indexes, so they are updatable. When I try to modify information in the
table (accessing the table directly through the database window) I get a
write conflict ("This record has been changed by another user since you
started...etc..etc") with the options of Copy to Clipboard and Drop Changes
(Save Record is greyed out). I am the only user in the database, there are
no triggers and this occurs with or without default values in the individual
columns in the back end table (FWIW there are only '0' defaults on numeric
and bit fields).

I've done a little googling, but most of my results have to do with VB code
or timestamp defaults, and nothing quite as strange as I'm encountering.

Any ideas?

Thanks!
Rick
Nov 21 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.