General ASP / Access DAO recordset question

[RobJDB]

Am I correct in thinking that, in an Access module, I can open a recordset and then use such commands as

rs.fieldname.value = "..."

to update the contents of the table on the fly, whereas in ASP, all I will change is the contents of the recordset, not the table itself?

Basically, I have used this in a DAO script to change the table's contents with success, but when I tried to use it on an ASP page, it didn't do the same thing. Anyone like to explain this?

Thanks, Rob

 

[Funka]

two things i can think of:

first, your MDB file could possibly be treated as read-only (for example if the IUSR_HOSTNAME user does not have access to the file)

second, (and i'm a bit rusty on DAO specifics since moving to ADO,) check your CursorType (static, keyset, dynamic?) and CursorLocation (server-side or client-side?) to make sure the recordset you're creating in ASP is actually updateable. also, you may have to call the "Update" method of the recordset once you've made changes to it in order to pass the updated information back to the cursor.

if you can post your code for creating and populating your recordset object, it would be helpful in diagnosing this further.

good luck!

 

[RobJDB]

Got it! Thanks for your help. I've got a static cursor type, an optimistic lock, and a server-side cursor location, and it works. Cheers!