update query fails

[norm dingle]

I have an Access 97 application that has been working for several years. I
have made an update to the application and now get an error message.

I am using an update query to talk to as SQL table. When it is run now I get
an error message that I must use an update query.

Does anyone have any ideas?

Norm

 

[Rick Brandt]

I have an Access 97 application that has been working for several years. I
have made an update to the application and now get an error message.

I am using an update query to talk to as SQL table. When it is run now I get
an error message that I must use an update query.

Does anyone have any ideas?

Sounds like Access is telling you that your link to the SQL table is Read-Only. Does
the table on the SQL Server have a primary key? if not you would have been asked
when you created the link originally to indicate which columns Access could use to
build a unique index on to make the link updateable. If you recently did something
to refresh the link, that information would have been lost and the link would revert
to Read-Only.