473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

MDE vs MDB Lauching external Apps.

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?
Jan 18 '07 #1
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
Jan 18 '07 #2
cyberdwarf
218 Expert 100+
Have you tried omitting the "Call" command?

Steve
Jan 18 '07 #3
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
Jan 18 '07 #4
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.
Jan 18 '07 #5
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.
Jan 31 '07 #6
NeoPa
32,556 Expert Mod 16PB
...And you have :
Expand|Select|Wrap|Line Numbers
  1. stAppName = "\\Library\Download\SE\MDB.bat"
  2. 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.
Jan 31 '07 #7
ADezii
8,834 Expert 8TB
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?
Jan 31 '07 #8
NeoPa
32,556 Expert Mod 16PB
SNAP :D
Jan 31 '07 #9
ADezii
8,834 Expert 8TB
SNAP :D
Is SNAP secret Moderator code?
Jan 31 '07 #10
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).
Jan 31 '07 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

2
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...
2
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,...
2
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...
4
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...
1
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...
3
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...
4
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...
13
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
3
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
0
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...
0
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...
0
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.