Conversion to Acc97: Query not updatable anymore
Posted on 1997-12-15
having updated our application from Access 95 to Access 97, most of our queries have become un-updatable.
We've corrected this by removing 'DISTINCTROW' from the SQL-statement. (See Knowledge-Base-Article Q168438.)
Now, you may change any entry in a query in the spreadsheet-view of the query, and *partially* you can do so in the form which uses the query as source.
The strange thing is that on *some* computers on which our application is running it's *not* possible to edit any values in the form (in spreadsheet-view still possible); the info in the status-bar is 'This recordset is not updatable' (which corresponds to error 3326).
What could be the cause? Can anyone explain?
mail to: firstname.lastname@example.org (*** to be deleted)