My client has a SQL Server 2008 backend with an ACCESS 2007 front end.
Most of the tables work fine linked using ODBC. However, two of them
do not let me edit them as linked tables. I can make changes to the
data using the SQL Server Management studio, but when I try to do that
through the linked MS Access table it tells me that someone else has
edited the table, even though that is not so. It will save the correct
data to the clipboard if I select that option, but I can't figure out
why it is locking the record.

The SQL Server is encrypted using the built in microsoft encryption.

All my other linked tables work fine...(there are lots of them.) i am
pretty comfortable with Access but my SQL skills are limited...

Any clues would be appreciated.

On Nov 10, 6:49*pm, Jim Mandala <jim.mand... (AT) gmail (DOT) com> wrote:
search 'timestamp field' in the newsgroup, there are good explanation
as to why your table needs one

On Nov 12, 8:23*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:
Thanks! I'll see if that is it! and post back.