Problem updating linked SQL table from mdb, addnew is OK

  • Thread starter Thread starter MB
  • Start date Start date
M

MB

I have an application that was migrated from an Access database to SQL.
Still using the mdb as a front end.

Problem is that I can add new rows to a table, but can't modify them later.
This is true using either a form or opening the table directly.

Problem is just with this 1 table.

This is new behavior, I can't figure out what has changed.
 
The first thing to check is that there are a primary key defined for this
table.
 
Did you change the schema of the table without refreshing the link? Or
maybe a strange field? What happens if you remove some or all the fields
excerpt one?
 
I just created test.mdb, linked to only the 1 table, created a form with
only the key & 1 field, can't update, get a write conflict error. I also
tried this with an adp, works fine. I know I changed something, just can't
imagine what it is.
--
 
Did you try to use SQL-Server Profiler to see what Access is attempting to
do?

And what about recreating the table? (One field at a time if possible.)

Any trigger?
 
Fixed !!

Don't really know what the problem was, copied the table, added the key,
renamed the old/new table and everything works fine.

I hate to admit this, but I don't know how to use the profiler. I think I
will take the time to get up to speed on it.


Thanks again !!

Marc Berman
 
Back
Top