• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

Executing SQL on a Form's Recordset

I have a form with a procedure that updates all records in the data set.  Using SQL is the most efficient way to do this (rather than looping through the form's recordset).  But if I use CurrentDb.Execute strSQL, the form barks at me about another user altering the recordset.  Is there a way to run the SQL within the scope of the form?  Perhaps a DAO or ADO command?

Mike
0
shacho
Asked:
shacho
  • 2
  • 2
1 Solution
 
mbizupCommented:
Mike,

Try saving the data on the form immediately before the CurrentDb.Execute strSQL statement.

To do this, you can use the following:
    docmd.RunCommand acCmdSaveRecord


0
 
shachoAuthor Commented:
Nice.  I think I see why that works.  Should have considered that.  Thanks a lot!

Mike
0
 
mbizupCommented:
That is the solution for a lot of similar issues... basically you want any data that is in the process of being edited to either be "undone" or fully committed to the table before beginning any seperate editing or saving process.  Otherwise, even if it is just the actions of one user, it has the net effect of multiple people stepping on each other's toes.
0
 
shachoAuthor Commented:
Indeed.  Makes sense.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now