Hi all,
I have two MSACCESS.EXE instances running on a machine. I'm looking to "Kill" one of the specific access databases.
Anyone have any ideas on how i can do this via VBA?
Hi all,
I have two MSACCESS.EXE instances running on a machine. I'm looking to "Kill" one of the specific access databases.
Anyone have any ideas on how i can do this via VBA?
there is, but how's it gonna know which access to kill?
say both apps are 'my db".
How was report runner opened? From explorer? Another app? If the latter you should be able to just close the db from the app that opened it
Mydbinstance.close
It's opened manually. However, i have another DB that monitors it to make sure it is running on schedule.
Sometimes its hangs up. When it hangs up and the other DB that monitors is detects the hang up, i was hoping to kill the Report Runner then restart it. Right now the DB that monitors it just notifies us and we restart it manually. Hoping to automate the restart process.
I'm not aware of any code that will 'kill' a specific instance of access, just all of them which I'm guessing you have already found.
Aside from not being able to get the name of the instance, all you can get is a number - (see task manager). you would need to dig down to find the name (aka clicking the down arrow next to each instance of access).
Not gone through it but you might find something in this thread
https://www.access-programmers.co.uk...rocess.321768/
@vlad - your link is a bit twisted - missing the s on https and has ): at the end
@Ajax: thanks, we are traveling and I'm not that good with the phones (and lack of good light\glasses)..:
http://forestbyte.com/vba-code-samples/
Cheers,