Editting Records in Access 97 mdb

I think the editing of records is perfectly possible. You only have to know the exact record (ie. the primary key value for the record) and the fieldnames which you have to edit. What you need to achieve is when the Submit button is clicked you have to get the new data in the textboxes either by the Get or by the Post method and then in the ASP page you need to check these values and update them in the database. Since I am not experienced in ASP, I can't offer much more advice.

.

I am not real familiar with ASP either, but the SQL should be something like this:

UPDATE [Table Name] SET [Table Name].[Field Name] = "[Value]"
WHERE ((([Table Name].[Primary Key])=[Key Value]));

You would have to run a SELECT statement before this to get the Primary Key Value.