ODBC - Update on Linked table 'xyz' failed?

[1DMF]

Hi,

Any idea why I cannot issue an update on a recordset that is currently in EditMode = 1 ?

I retrieve the record with

dbOpenDynaset, dbSeeChanges, dbPessimistic

I issue the Edit command and it puts the record in edit mode, I change values of the recordset fields, but when 'update' is issued it errors with

ODBC - Update on Linked table 'xyz' failed?

Any ideas why?

Thanks,
1DMF

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads

 

[1DMF]

I have also done

msgbox rs.Updateable

which returns 'True', so how do I find what is stopping the update?

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads

 

[1DMF]

OK, worked it out!

I had a loop which collected the data from an unbound form and then updated each field in the recordset.

One of the fields was also the table primary key and although it was replacing this value with the value it was to start with, I can only assume that this causes an issue as it must see this as an alteration to the primary key even though the value itself hasn't changed.

As soon as I removed this field from the loop, the update worked fine!

Thanks,
1DMF

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads