Originally Posted by Pat Hartman
No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model.
Actually, I found out since I created this thread, that you can but you have to execute the sql through ADO. Why, I don't know, but it did work.