Editing SQL data on an Access form

[chris_visible]

I have to use Access 97 to allow a user to edit data in an SQL back end database. I am using pass-through queries to call Stored Procedures and I am not able to edit the results.

I have tried creating extra text boxes to insert data and then run an Update stored procedure to put the data entered by the user into the desired field. This works fine for Access forms set with a Default View of Single but does not work on if is a continuous form. When I enter a vale it always updates the first record on the form.

Is there a way of binding the Text box’s to the records so that it can be used to edit the selected record?

Please post requests for any further detail you may require to answer this question.

Many Thanks

 

[Pat Hartman]

If you link the tables and use Access queries based on the linked tables, your forms will be updateable. Is there some special reason that you are using pass-through queries and stored procedures?