Can anyone tell me if there's a way to tell through VBA if an application is already running? Not just to see if Access is running but a specific Access app? I have to know this before launching another part of the job.
Thanks in advance.
Glenn
Can anyone tell me if there's a way to tell through VBA if an application is already running? Not just to see if Access is running but a specific Access app? I have to know this before launching another part of the job.
Thanks in advance.
Glenn
usually if you see the lock file.
for data.accdb app
the lock file data.laccdb will exist telling you someone is in it.
This is not 100% true, because it can exist if a user crashed, but it 99% true