Doug Cacialli wrote: > Lo, > > 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. > > The problem seems to be that when Perl gets to that initial open function, > it hangs > because it can't really open the database (which is really what I'm asking > it to do > there) without the password. It never gets to the print. And of course, > there's no > frolicking or cartwheels. > > Does anyone know how I can get around this? Is there someway to use the > open function without having Perl wait and see what happens? Does anyone > know of a better way to do this? Any help would be great! >
try: open(ACCESSDB,"| C:\\Documents\ and\ Setting\\Doug\Cacialli\\Desktop\\TESTDATABASE.mdb /user <user name> /pwd <password>") || die $!; /usr <user name> and /pwd <password> are command line option to supply Access with a user name and a password. see if that helps you or not if the above doesn't work: try: open(ACCESS,"| path\\to\\your\\Msaccess.exe /user <user> /pwd <psw> path\\to\\your\\access.mdb") || die $!; my knowledge to the Windos world is very limited so i can't help beyond this simple advice. david -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
