MS Access, Access 97 won't let me delete records on a SQL linked table (2000 will)

Access 97 won't let me delete records on a SQL linked table (2000 will)

Author	Message
MWS #1 / 2	Access 97 won't let me delete records on a SQL linked table (2000 will) I have converted an Access 2000 app to 97 and a couple of delete queries give me an error: "Operation Must Use an updatable query." The query is to a linked table on SQL 6.5. DELETE * FROM dbo_FieldServiceReport_SQL where id = 99 How can I delete records on SQL using a linked table in Access 97?
Tue, 14 Sep 2004 08:05:27 GMT

Scott McDanie #2 / 2	Access 97 won't let me delete records on a SQL linked table (2000 will) Try removing the * in the query ... Quote: > I have converted an Access 2000 app to 97 and a couple of delete queries > give me an error: "Operation Must Use an updatable query." > The query is to a linked table on SQL 6.5. > DELETE * FROM dbo_FieldServiceReport_SQL where id = 99 > How can I delete records on SQL using a linked table in Access 97?
Tue, 14 Sep 2004 10:12:30 GMT

Page 1 of 1

[ 2 post ]