Check out the Win32::SetupSup module. You should be able to open the
program via system, find the window, and send the keystrokes to it using
this module.
-Original Message-
From: Cacialli, Doug [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 10:16 AM
To: '[EMAIL PROTECTED]'
Subject: opening MS ACCESS via the system function
Lo,
I'm attempting to write a program that will run daily, and perform the
following actions:
1. Open a database in MS Access 2002,
2. Execute a program in SAS v8.02 that will, simply put, do a lot of
statistical analyses and compare the current database to the backup from the
night before to identify any changes, and
3. Generate a txt report summarizing the analyses and send the report to a
handful of users via email.
The problem is this: I have user-level security B.S. on the MS Access
database. In order for SAS to do its things, the Access database needs to
be open, which I was going to do via the perl system function. However, I
can't open the database without providing Access with a logon and password.
Does anyone have any ideas or suggestions here? Is there a way to send the
logon and password when I invoke the Access via system? I know there's a
DBD::ODBC module that I can use to get at the data, but I'm pretty sure that
it won't open the database. ANY suggestions or ideas would be appreciated.
This is my first program in perl. Thanks.
Doug out.
---
Douglas Cacialli - Data Manager / Data Analyst
Sleep and Depression Research Laboratory
University of Rochester Medical Center
300 Crittenden Blvd. - Box PSYCH
Rochester, New York 14642
Phone: (585)273-3309 Fax: (585)506-0287
NOTE NEW FAX NUMBER
---
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
