update query fails

  • Thread starter Thread starter norm dingle
  • Start date Start date
N

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
 
norm dingle said:
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?
Click to expand...

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.
 
Back
Top