Hi,
I need to find how can I know that a program I am going to shell it is
already open.
This program uses an csv file that I need to refresh before shelling
the program, however if the csv file is already in use because the
program is open I cannot refresh it (kill it and rewrite it) and I do
not get any error message.
Right now I have a message the prompts the user to close the robot
software before opening it through the database. Is there a better
method?
I appreciate your help.
Stefania Scott 6 2568
You could use the Windows API to see if the program is open.
This should get you started on checking to see if the program is open. The code here
checks to see if a copy of your database is already open, but you should be able to modify
it. http://www.mvps.org/access/api/api0041.htm
You could also try to open the file with a lock and see if you get an error message back.
This will only work if the other program locks the file when opening it.
--
Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message
news:3e**************************@posting.google.c om... Hi, I need to find how can I know that a program I am going to shell it is already open. This program uses an csv file that I need to refresh before shelling the program, however if the csv file is already in use because the program is open I cannot refresh it (kill it and rewrite it) and I do not get any error message. Right now I have a message the prompts the user to close the robot software before opening it through the database. Is there a better method?
I appreciate your help.
Stefania Scott
Wayne,
Thank you for yor reply.
I looked into another api call, that checks if an application is
running, which is all I need to do. However, for this to work I need
the class name of the application. How can I determine the class name
of an application?
The API call I a trying to use is: http://www.mvps.org/access/api/api0007.htm
Thank you.
Stefania
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<CN*****************@newssvr17.news.prodigy.c om>... You could use the Windows API to see if the program is open.
This should get you started on checking to see if the program is open. The code here checks to see if a copy of your database is already open, but you should be able to modify it.
http://www.mvps.org/access/api/api0041.htm
You could also try to open the file with a lock and see if you get an error message back. This will only work if the other program locks the file when opening it.
-- Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message news:3e**************************@posting.google.c om... Hi, I need to find how can I know that a program I am going to shell it is already open. This program uses an csv file that I need to refresh before shelling the program, however if the csv file is already in use because the program is open I cannot refresh it (kill it and rewrite it) and I do not get any error message. Right now I have a message the prompts the user to close the robot software before opening it through the database. Is there a better method?
I appreciate your help.
Stefania Scott
You may have to check with the maker of the application.
--
Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message
news:3e*************************@posting.google.co m... Wayne, Thank you for yor reply. I looked into another api call, that checks if an application is running, which is all I need to do. However, for this to work I need the class name of the application. How can I determine the class name of an application?
The API call I a trying to use is: http://www.mvps.org/access/api/api0007.htm
Thank you.
Stefania
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:<CN*****************@newssvr17.news.prodigy.c om>... You could use the Windows API to see if the program is open.
This should get you started on checking to see if the program is open. The code here checks to see if a copy of your database is already open, but you should be able to
modify it.
http://www.mvps.org/access/api/api0041.htm
You could also try to open the file with a lock and see if you get an error message
back. This will only work if the other program locks the file when opening it.
-- Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message news:3e**************************@posting.google.c om... Hi, I need to find how can I know that a program I am going to shell it is already open. This program uses an csv file that I need to refresh before shelling the program, however if the csv file is already in use because the program is open I cannot refresh it (kill it and rewrite it) and I do not get any error message. Right now I have a message the prompts the user to close the robot software before opening it through the database. Is there a better method?
I appreciate your help.
Stefania Scott
Dev and Terry wrote a little mini SPY program that you can use. http://www.mvps.org/access/modules/mdl0032.htm
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Wayne Morgan" <co***************************@hotmail.com> wrote in
message news:ex***************@newssvr23.news.prodigy.com. .. You may have to check with the maker of the application.
-- Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message news:3e*************************@posting.google.co m... Wayne, Thank you for yor reply. I looked into another api call, that checks if an application is running, which is all I need to do. However, for this to work I need the class name of the application. How can I determine the class
name of an application?
The API call I a trying to use is: http://www.mvps.org/access/api/api0007.htm
Thank you.
Stefania
"Wayne Morgan" <co***************************@hotmail.com> wrote in
message news:<CN*****************@newssvr17.news.prodigy.c om>... You could use the Windows API to see if the program is open.
This should get you started on checking to see if the program is
open. The code here checks to see if a copy of your database is already open, but you
should be able to modify it.
http://www.mvps.org/access/api/api0041.htm
You could also try to open the file with a lock and see if you get
an error message back. This will only work if the other program locks the file when
opening it. -- Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message news:3e**************************@posting.google.c om... > Hi, > I need to find how can I know that a program I am going to shell
it is > already open. > This program uses an csv file that I need to refresh before
shelling > the program, however if the csv file is already in use because
the > program is open I cannot refresh it (kill it and rewrite it) and
I do > not get any error message. > Right now I have a message the prompts the user to close the
robot > software before opening it through the database. Is there a
better > method? > > I appreciate your help. > > Stefania Scott
Thanks Stephen,
I just downloaded it for myself.
--
Wayne Morgan
"Stephen Lebans" <St***********@mvps.org> wrote in message
news:ln********************@ursa-nb00s0.nbnet.nb.ca... Dev and Terry wrote a little mini SPY program that you can use. http://www.mvps.org/access/modules/mdl0032.htm
Thank you.
Stefania
"Stephen Lebans" <St***********@mvps.org> wrote in message news:<ln********************@ursa-nb00s0.nbnet.nb.ca>... Dev and Terry wrote a little mini SPY program that you can use. http://www.mvps.org/access/modules/mdl0032.htm
--
HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:ex***************@newssvr23.news.prodigy.com. .. You may have to check with the maker of the application.
-- Wayne Morgan
"Stefania Scott" <st******@u.arizona.edu> wrote in message news:3e*************************@posting.google.co m... Wayne, Thank you for yor reply. I looked into another api call, that checks if an application is running, which is all I need to do. However, for this to work I need the class name of the application. How can I determine the class name of an application?
The API call I a trying to use is: http://www.mvps.org/access/api/api0007.htm
Thank you.
Stefania
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<CN*****************@newssvr17.news.prodigy.c om>... > You could use the Windows API to see if the program is open. > > This should get you started on checking to see if the program is open. The code here > checks to see if a copy of your database is already open, but you should be able to modify > it. > > http://www.mvps.org/access/api/api0041.htm > > You could also try to open the file with a lock and see if you get an error message back. > This will only work if the other program locks the file when opening it. > > -- > Wayne Morgan > > > "Stefania Scott" <st******@u.arizona.edu> wrote in message > news:3e**************************@posting.google.c om... > > Hi, > > I need to find how can I know that a program I am going to shell it is > > already open. > > This program uses an csv file that I need to refresh before shelling > > the program, however if the csv file is already in use because the > > program is open I cannot refresh it (kill it and rewrite it) and I do > > not get any error message. > > Right now I have a message the prompts the user to close the robot > > software before opening it through the database. Is there a better > > method? > > > > I appreciate your help. > > > > Stefania Scott
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: muser |
last post by:
Karl this is albeit your program, in the program that you wrote for me
I learned quite alot, i didn't realise I could return NULL for
instance or even use functions without first declaring them,...
|
by: Pie |
last post by:
I like to have my program (running on my home machine)
email me (wherever I am) whenever it reaches a certain mile-stone
(finishes a phase of the simulation or runs into an interesting
path in the...
|
by: P |
last post by:
Hi,
Access 2002. I use DoCmd.OpenForm attached to command buttons to open one
form from another form. All forms are open in dialog mode. When a user tries
to open a form already opened from a...
|
by: Gos |
last post by:
Hi,
I have a program that needs to open a list of attachments
displayed on a ListView. I have used Process.Start method to open the
files using their associated program. This works correctly if...
|
by: nisha |
last post by:
A#include<fstream.h>
#include<conio.h>
#include<stdio.h>
#include<ctype.h>A
#include<graphics.h>
#include<process.h>
fstream dat,dat1;
float gsal,pf;
char flname={"dsb"};
class emptax
| |
by: keri |
last post by:
Hi,
I use the below for the user to view their outlook calendar
Sub DisplayInbox()
Dim myolApp As Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim myFolder As Outlook.MAPIFolder...
|
by: cs |
last post by:
Hi,
I'm new to C and would appreciate any feedback on the following
program, asplit, which splits a file into 2 new files, putting a
certain number of lines in the first file, and all the rest...
|
by: midknight5 |
last post by:
Heya everyone, I am a freshman in college and am taking C++. This is not a begging thread for someone to solve my problem because I am interested in learning this myself.
So here is my question:...
|
by: Keith G Hicks |
last post by:
I'm having a lot of trouble with "file in use" errors in my "folder watcher"
project. Starting and stopping the watcher and reading my XML file work
fine. Once the watcher is started, I'm reading...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |