I have a need to process about 500+ updates to an Access97 table. Simple query, but it is record by record. (I can write sql, but have not mastered VBA..and my problem is that I need to do this today..)
In other SQL’s I have worked with you could “stack” multiple queries. Like
updateqry#1….;
updateqry#2….:
and so on.
I created a file that has all the update statements built, all terminated with a “;”
But near as I can tell, either MS JetSQL doesn’t support multiple update statements in the same query, I am using the wrong end of statement char or I am doing something else wrong.
Checked the web, checked my books, checked the on-line Access 97 help, but can not find anything that says yes I can or cannot do it.
Any suggestions would be greatly appreciated.
Thanks inadvance.
Doug Cranston