Open "SELECT * FROM [User] WHERE Home Remote ID = '0'", _ obj Connection, ad Open Static, ad Lock Optimistic obj Record Set. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

I am trying to locate information on how to apply SQL methods for my application. Examining a record deleted from a batch update recordset 9. Recordset.status doesnt change when record updated ?? Open Recordset([tablename / sql]) myrecodset.fields("myfield") = [somevalue] myrecordset.update TIA Michelle Hi Using A2003 on XPI am wondering from the MVP's and others, what is the most efficient way (interms of time to process) of updating data in a table, using thedocmd. eg: (if you need it)1.--------------------------mysql = "Update [mytable] SET [Some Field] = [somevalue];"docmd. Run SQL mysql 2.-----------------------set myrecordset = mydb. Ok, I going to expose my ignorance of handling remote record Sets and/or Views in ADO.I'm in the planning stage of a project using Flash Remoting and ADO . The Flash client has no problem consuming an ADO record Set then after updating, passing it back to the object and reconstructing the record Set with the changes.