"Kill" specific Access instance

**ry94080** · 06-24-2022, 08:20 AM

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?

**ranman256** · 06-24-2022, 09:03 AM

there is, but how's it gonna know which access to kill?
say both apps are 'my db".

**ry94080** · 06-24-2022, 09:12 AM

Originally Posted by ranman256

there is, but how's it gonna know which access to kill?
say both apps are 'my db".

I would like to "Kill" the Access application that has the title "Report Runner".

**CJ_London** · 06-24-2022, 10:03 AM

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

**ry94080** · 06-24-2022, 10:05 AM

Originally Posted by Ajax

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.

**CJ_London** · 06-24-2022, 10:47 AM

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/

**Gicu** · 06-24-2022, 04:42 PM

Maybe this might help (from http://forestbyte.com/vba-code-samples/):

Cheers,
Vlad

**CJ_London** · 06-24-2022, 04:52 PM

@vlad - your link is a bit twisted - missing the s on https and has ): at the end

**Gicu** · 06-25-2022, 04:18 PM

@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,

"Kill" specific Access instance

Thread Tools

"Kill" specific Access instance

Similar Threads

Best Practice for Creating a "Playlist" or "Album" type function within Access

Login to Access as "Admin" or "User" allowing different Editing, Additions and Deletions permission

"package" reports into a form to allow "print", "choose Printer" etc easier for user

Query and form for "Customers" interested in specific "Products"

"Kill" statement works in immediate pane, but not in module loop

Posting Permissions