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]
