i have created a record on a linked table from within ms access using a stored procedure in sql server 2005. the insert record proc sends a 0 return code. i can view the record, but when i try to update it via a form, i get a 3021 error "No current Record". when i try to update it manually in the table i get a write conflict error. any suggestions on where to look for my problem?
-
-
It seems to me, since you say the table is linked (had no idea you could also link SQL tables inside Access) that the two can't talk to eachother. The stored procedure runs locally through / inside MS SQL hence the INSERT works. But unless you have a stored procedure for updating, I don't think you well get it to work as it is. Transporting into a recordset/tabledef and back might be a good workaround if you have no problems with reading the data.
Comment