R
Rico
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
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