Hi,
im not very skilled in VBA (or access) and im a litle stucked.
My problem (challenge) is that i have aprox 25 different queries (both apend queries, delete and update) that i run once a month. These have to be run in a spesific order.
Up til now i have used VBA code as: openquery "my query name" with all warnings switch off (Set warnings (false).
Also tried: dbs.execute ....
The challenge is that:
1) both methods ignore warnings perfectly, but one or two queries run into system resources issues. When query runs the warning (if not switched of) would say that "task cant be undone if i continue". I say yes and case closed. With warnings turned off it seems that default answer is no and query is not run.
2) When i run with execute comand Acces goes straight into "not responding" and stays that way for hours. With openquery method this is not an issue. Im happy with openquery method if issue 1 could be solved. My users cant sit in front of the program for an hour (that is how long all queries take to run on a good day).
Is there any way to run all my queries and make sure that they run no matter what? And, maybe get a log or something that show how the queries are executed?
hopefully,
erik
im not very skilled in VBA (or access) and im a litle stucked.
My problem (challenge) is that i have aprox 25 different queries (both apend queries, delete and update) that i run once a month. These have to be run in a spesific order.
Up til now i have used VBA code as: openquery "my query name" with all warnings switch off (Set warnings (false).
Also tried: dbs.execute ....
The challenge is that:
1) both methods ignore warnings perfectly, but one or two queries run into system resources issues. When query runs the warning (if not switched of) would say that "task cant be undone if i continue". I say yes and case closed. With warnings turned off it seems that default answer is no and query is not run.
2) When i run with execute comand Acces goes straight into "not responding" and stays that way for hours. With openquery method this is not an issue. Im happy with openquery method if issue 1 could be solved. My users cant sit in front of the program for an hour (that is how long all queries take to run on a good day).
Is there any way to run all my queries and make sure that they run no matter what? And, maybe get a log or something that show how the queries are executed?
hopefully,
erik