ASP update record in MS Access

[critters]

Rather new to ASP. I’m trying to get a value from one field in one record (using the primary key to select) in an Access database table, add 1 to that value, then write the new value to the same record in the database table.

1. I can’t get it to select the proper record, it just selects the first record.
2. I can get a value (just not from the right record) and increment the number, but it doesn’t update the record.

Please help if you can,

Thanks,

Critters

[John]

Hi,

Are you using ASP-db to do this? If not, you really should. Check out www.aspdb.com. This forum is dedicated to support of that product.

Thanks,
John