| David Frick 2002-11-09, 7:23 pm |
| I created a blank Access 2002 database and linked 4 tables from SQL Server
2000.
I have done this lots of times and never had any problems. This time one of
the four tables will not allow me to perform an update on any of the fields.
When I make a chnage in the field and move off the record, I get an error
telling me a concurrent user has made changes and if I save I will overwrite
their changes. However, the "save" button is grayed out.
I am the only user in the database at the time I get this message. I
stopped and started the SQL Server service to make sure there was nothing
holding a lock on this table. The table has a trigger on it, which I
disabled, but so do the other 3 tables. I have no problem updating the other
tables.
Does anyone have any idea why this simple linked table will not allow me to
update records?
Thanks
Dave
|