467,134 Members | 947 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Write conflict on SQL 2000 ODBC linked table


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?

Nov 21 '08 #1
  • viewed: 1522

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Dave | last post: by
4 posts views Thread by crystal@cinstall.com | last post: by
1 post views Thread by steven_nospam at Yahoo! Canada | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.