I've got a Microsoft Access program that needs to be opened 24/7 on a specific computer.
I would like to create a windows service that checks to see if a specific MDB is open. If it isn't, I want the windows service app to open it up.
Now, I've used the shell command and process.start but instead of actually opening the mdb up for the users to see, it opens it up and I can see it in the process tab of the windows task manager. It doesn't matter what I do...if I use a batch file, shell command, or even a vbs script (I call the script of batch file), it opens it up in the process tab, but that is it.
If I put this code in a windows form and push a button, it opens up.
Is this a limitation to using a windows service?
I'm using Visual Studio 2008.
Thanks.
Simple Man