Re: strpco question

At 11:22 06/15/2000 , Angie Wawrzaszek wrote:
>I am trying to start an Access database with the strpco and strpccmd.  But 
>I keep gettin bad command  or file name.   I can  RUN this same path name 
>from the   START/Run path.  This database brings down data from the AS/400 
>to be used by access for display on the web page.  I would like to 
>automate the process of the update by running it in the early a.m.
>
>    CHGVAR     VAR(&CMD) +
>                 VALUE('\\AUSTEEL.AUSTEEL.COM\HOME\+
>                 AUBURN PURCHASING\PURCH_UPDATE.MDB')

Angie,

Here's a few ideas. Take them for what they're worth (wild guesses). Can 
you run some trivial command using strpccmd, like DIR? I think with strpco, 
you are required to be logged on. It's been a long time since I've used it, 
but it was always in the context of an interactive job doing something on 
the PC that was running the job. If you're not logged on, you can use 
RUNRMTCMD. That requires the remote command servce. You might try executing 
msaccess.exe and passing the database path as a parameter instead of 
depending on Windows to provide the connection, which may or may not be 
present. Also, if you're not logged on to the PC, be careful that there are 
no external links in the database that rely on drive mappings. I have run 
into several situations where I could do things interactively with Access, 
but not through a remote command because external links specified a mapped 
drive. Drive mapping is done when you log on, so mappings are not available 
to services. Network drives must be accessed via UNC paths, and the user ID 
under which the service is running must have access to the network resources.

hth
Pete

Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---