Sandy, thank you for the offer! At present, we are looking to run this system via an Access database on the Mail Server. Our administrative system produces and transfers a CSV file nightly of accounts to add. We have VB scripts run against these CSV's to create various other accounts. I will obviously need to learn queries soon, but any script framework or a good primer on VB connection strings, etc. would be extrememly helpful. The value we would like to see for the TYPE filed of new users is 197000.
Thanks again. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanford Whiteman Sent: Monday, March 24, 2003 11:57 AM To: Dave Koontz > As a school, we constantly add and remove accounts in mass. For this > reason, we would like the account created with proper Web > preferences at time of creation. Let me know what the "proper" web preferences are for your org and whether you want this for Access or MSSQL. I'll whip up a VBS and post it. If you're using a SQL-capable DB as an everyday tool, this might be s good time to familiarize yourself with basic queries. There's really no reason to be creating users any other way if you're using IMail's ODBC option! One additional question: where's your CSV file coming from? Is that itself manually entered? If so, this whole thing is redundant, as you could just enter the data into the SQL table directly. -Sandy ------------------------------------ Sanford Whiteman, Chief Technologist Broadleaf Systems, a division of Cypress Integrated Systems, Inc. e-mail: [EMAIL PROTECTED] ------------------------------------ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
