I have written an external batch file that I use to auto update my access app when I place a new version on the server. Depending on the users needs and permissions they either use an MDB front end or an MDE.
I use
"Call Shell(stAppName, 1)" with
stAppName = "\\Library\Download\SE\MDE.bat"
to launch the Batch file.
This works with the MDB but it will not work with the MDE. I have also tried "Application.FollowHyperlink stAppName" with the same results. Is there a way I can launch an external batch file with an MDE?
10 3112
I see that I didn't get any replies. If I did not write my question clearly enough or if I did not put enough information in my question, please let me know. I am using MS Access 2003 with an application that has several back end access databases.
Thank You,
Randy
Have you tried omitting the "Call" command?
Steve
NeoPa 32,556
Expert Mod 16PB
I see that I didn't get any replies. If I did not write my question clearly enough or if I did not put enough information in my question, please let me know. I am using MS Access 2003 with an application that has several back end access databases.
Thank You,
Randy
Randy,
Your question seems clear enough, but please be patient. Members have ordinary jobs as well as donating some of their free time on here.
MODERATOR
NeoPa 32,556
Expert Mod 16PB
I have written an external batch file that I use to auto update my access app when I place a new version on the server. Depending on the users needs and permissions they either use an MDB front end or an MDE.
I use
"Call Shell(stAppName, 1)" with
stAppName = "\\Library\Download\SE\MDE.bat"
to launch the Batch file.
This works with the MDB but it will not work with the MDE. I have also tried "Application.FollowHyperlink stAppName" with the same results. Is there a way I can launch an external batch file with an MDE?
Have you tried running the batch file outside of Access - directly from the command line?
Does it work from there?
The Call part of the command will not be causing any adverse effects here btw.
A good suggestion, but I use that in my code all the time to highlight I'm calling a procedure. Makes it easier to read.
Have you tried running the batch file outside of Access - directly from the command line?
Does it work from there?
The Call part of the command will not be causing any adverse effects here btw.
A good suggestion, but I use that in my code all the time to highlight I'm calling a procedure. Makes it easier to read.
The batch file runs fine outside of Access. In fact our IT staff have gone to using it in the interim until I can get the Auto Update working with the MDE.
NeoPa 32,556
Expert Mod 16PB
...And you have : - stAppName = "\\Library\Download\SE\MDB.bat"
-
Call Shell(stAppName,1)
working fine?
I can't think of anything that would be different for an MDB file.
Can you post the contents of both of the Batch files in here for me please.
I know it's an Access forum but I do have extensive experience with Batch & Cmd files. I'd be interested to compare them and also to see exactly what is going on therein.
The batch file runs fine outside of Access. In fact our IT staff have gone to using it in the interim until I can get the Auto Update working with the MDE.
There is no logical reason why it does not work in an .mde format. It must be the Batch File itself. Can you post its contents?
NeoPa 32,556
Expert Mod 16PB
SNAP :D
Is SNAP secret Moderator code?
NeoPa 32,556
Expert Mod 16PB
SNAP is what you say (shout) when you both lay the same card down (In the card-game Snap).
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Thang Nguyen |
last post by:
Hi,
my page contains an applet. When I click on a link on the page, the
applet will be launched.Now I need my page can be automatically closed
when I close my applet.I can call the script from my...
|
by: Harry Stangel |
last post by:
Noble reader,
My goal is to obtain the current time on the web server and display it in
the client's browser. I want the server time displayed independent of the
client's current clock setting,...
|
by: Edward |
last post by:
I'm trying to execute an application on the server side in
asp.net. For a simple test, I wanted to run notepad.exe
which I copied from the windows directory to my web app
directory. Here's the...
|
by: Jerry Camel |
last post by:
On the WebLogic side of our development team, we use JNDI and access
datasources that are defined outside the actual application. This is an
advantage in several ways... Not the least is becasue...
|
by: Dominic via DotNetMonster.com |
last post by:
I am a CA-OpenROAD programmer, but I attempting to build some VB.NET DLLs
and access them through OpenROAD as an external Windows TypeLib.
I have managed to build a simple DLL (code follows) but...
|
by: Big Charles |
last post by:
Hi,
We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the...
|
by: =?Utf-8?B?TEJU?= |
last post by:
Good day,
I would like to execute an external application from a web form created
using ASP.Net. I'm using System.Diagnostics.Process. It works fine if it is
notepad.exe but it is not able to...
|
by: =?Utf-8?B?YW1pdF9taXRyYQ==?= |
last post by:
I Need to forcefully Abandon ASP.NET sessions from an external Windows
application or another site. Please help how can i implement this
|
by: IanReardon |
last post by:
Is it possible to configure an external SMTP server to route all of
your outgoing mail through on Linux?
I know in php.ini there is a parameter, but it says its only for
windows? Can I do this...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |