View Single Post
  #1 (permalink)  
Old March 16th, 2004, 02:19 PM
Dataman Dataman is offline
Authorized User
 
Join Date: Jun 2003
Location: Glendale, AZ, USA.
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADO Recordset and SQL Statements

Hi there,

   I have a fully updatable ADO recordset from SQL Server in my Access 2003 database. Is it possible to apply a SQL Statement to the recordset. What I'm trying to do is apply and update SQL statement to the recordset and when I'm finished with all the changes, I will use the updatebatch method of the ADO recordset object when I'm finished making all the changes. Doing this will allow me to not have to make a trip to the SQL server box for each change. Is it possible to perform this...I thought I read that you could somewhere, but can't find any documentation in the help files/books.

Thanks,
Mike
Reply With Quote