Making hidden Access sessions visible.

[petertenthije]

We have a computer that is used exclusively to run automated processes using windows taskplanner and VBS scripts.

This computer also opens Access databases to update them. Some of these are running in the background, with the Access session not visible.

With Windows Taskmanager I can see that one (or more) MSACCESS.EXE *32 sessions are running. But I can't open this session using Taskmanager. When I right-mouseclick I can select "Open location" (or something like it, translating from Dutch)... but that only shows the location of the Access program, not the specific database. Same when opening properties.

Is there a way to unhide these Access sessions, so I can see which specific databases are running?

I know it is possible to do so for hidden Excel sessions (code: Getobject(, "Excel.Application").Visible = true in VBA>Immediate screen), but for Access I am at a loss.

 

[Trevor G]

This YouTube video may help it does suggest an app called TrayIT

which also means you can access what's running form the system tray and activate it.

 

[petertenthije]

Thanks for your suggestion, but I am not sure that's going to work for me. My IT department is rather strict on installing software and apps.

 

[RoryA]

I know it is possible to do so for hidden Excel sessions (code: Getobject(, "Excel.Application").Visible = true in VBA>Immediate screen), but for Access I am at a loss.

Why can't you do the same for Access?

 

[petertenthije]

Why can't you do the same for Access?

I tried, but it just does not work.

 

[RoryA]

It works for me. What version of Access are you running?

 

[petertenthije]

I think it’s 2016, I’ll check tomorrow when I’m at the office.

 

[RoryA]

I tested with 2016 and it worked for me. (Of course if you have an existing instance of Access visible, it will likely just make that visible again)

 

[Micron]

If you can't alter the code that opens the db hidden, then since you're looking in Task Manager anyway, just get the db name there?

 

[petertenthije]

If you can't alter the code that opens the db hidden, then since you're looking in Task Manager anyway, just get the db name there?

In the task manager you can not see the name of the database. Only that Acces is running.