I have a query that runs on a large number of records. Midway theough the execution I get a system message saying that access can't undo the effect of this action query due to disk space or memory constraints. Disk space is fine so it must be memory. I know that I will not want to undo changes so my question is how may I prevent this confirmation message appearing?. I have setwarnings to false already.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Switch off warnings
- Thread starter mfd777
- Start date
LonnieJohnson
Programmer
If it is an action query, you can use the RunSQL command.
In VB you would do:
Docmd.RunSQL "UPDATE CUSTOMER SET CUSTOMER.NAME = 'John Smith';"
You can also do it in a macro but there is a limit to the number of characters you can put in the SQL string.
Hope this helps.
In VB you would do:
Docmd.RunSQL "UPDATE CUSTOMER SET CUSTOMER.NAME = 'John Smith';"
You can also do it in a macro but there is a limit to the number of characters you can put in the SQL string.
Hope this helps.
- Status
Similar threads
- Locked
- Question