From: "Cacialli, Doug" <[EMAIL PROTECTED]>
> I apologize if this request is less than coherent.
>
> I'm running Win XP Pro using Perl 5.6.1. I'd like to do this:
>
> open (ACCESSDB, "| C:\\Documents\ and\ Settings\\Doug\
> Cacialli\\Desktop\\TEST
> DATABASE.mdb")
> or die "Something is amiss: $! \n";
>
> Which starts Access, and requires the user to enter a password, which
> I would do:
>
> print ACCESSDB "password\n";
> close (ACCESSDB);
>
> At which point Access would open up the database, and I could go on to
> live my happy life, frolicking around, doing cartwheels, whatnot.
1) If there are spaces in directory and file names under windows you
are supposed to enclose the path in doublequotes in the command.
open (ACCESSDB, '| "C:\Documents and Settings\Doug
Cacialli\Desktop\TEST DATABASE.mdb"')
2) Access doesn't expect to get ANYTHING from its standard input
(STDIN). If you want to fill some dialog you have to use a module for
this. Try to install Win32::Setupsup and read its docs
c:\> ppm install Win32-Setupsup
c:\> perldoc Win32::Setupsup
Then you will start the Access using system() or Win32::Process
instead of open() and find the right window and send the password
there.
Jenda
=========== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ==========
There is a reason for living. There must be. I've seen it somewhere.
It's just that in the mess on my table ... and in my brain
I can't find it.
--- me
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
