Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL SELECT seems to lose the "SELECT" keyword

Status
Not open for further replies.

Soundsmith

Programmer
Feb 21, 2001
84
US
In Access 2000, I can run a series of UPDATE statement like this:

DoCmd.RunSQL "UPDATE qryRptlink SET ok = True"

They run fine. BUT, following this command with:

DoCmd.RunSQL "SELECT [qryNames].* FROM [qryNames}"

Access complains "A RunSQL action requires an action consisting of an SQL statement"

It appears Access is not seeing my SELECT keyword.
What am I missing???
David 'Dasher' Kempton
The Soundsmith
 
runsql is intended for action queries or data definition queries
use openrecordset or createquerydef instead
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top