01-31-05, 16:36 #1Registered User
- Join Date
- Jan 2005
Unanswered: Help: Need to Edit Multirecord disconnected ADO recordsets
I'm using MS Access 2002 as front end to MS SQL Server 2000 database. I want to handle all interactions through stored procedures but edit data using MS Access forms. Single-record forms allow me to edit values in disconnected recordsets, but continuous or datasheet forms don't. Using single-record forms I create the recordset and loop through the fields collection assigning the values to the appropriate fields in the form. I update the values no problem.
Is there a similar thing I can do for continuous forms or datasheets for the multi-record datasets? For these I set the forms recordset property to the disconnected ADO recordset. I am able to addnew and display the values from the code, but not update the values on the form. There is a work-around where I use a hidden single-record form to add values, but I would rather not go this route. Any suggestions?
02-01-05, 02:05 #2Cavalier King Charles
- Join Date
- Dec 2002
- Préverenges, Switzerland
?? SELECT into a client-side temporary table and drive your form from that. when done editing run thru the temp table to feed your sp with updated values ??
izycurrently using SS 2008R2