I have MS Access 2007. How do I set a query's "Use Transaction" property to NO? I don't see this in the list of query properties. Please see attached document. I have Access 2007.
Ben
Ps. I have queries that run for very long just to get a message that there is not enough memory to undo the transaction. I always reply Yes. I do not need the undo functionality. I read that by setting the "Use Transaction" property to NO will stop Access from trying to do the undo.