John Colby
jcolby at colbyconsulting.com
Thu Jun 12 06:13:20 CDT 2003
Yep, we are trying to do that. this server has less than 200 mb free on it's C: drive. All by itself that is a cause for concern. Now try to squeeze Access and outlook in. And they wonder why the thing is slow! John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark L. Breen Sent: Thursday, June 12, 2003 4:01 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Exchange server Hello John, Can you not just ensure that Outlook is also installed on the Server, and run it from outlook on that machine, it should never be down. If for some reason, you cannot do that, can you install outlook on another server and do the same thing. Mark ----- Original Message ----- From: "John Colby" <jcolby at colbyconsulting.com> To: "AccessD" <AccessD at databaseadvisors.com> Sent: Wednesday, June 11, 2003 6:38 PM Subject: [AccessD] Exchange server > My client uses Exchange server. > > I currently have Outlook running on an employee's workstation, and he > receives emails form their client with attachments which have to be > processed by the database. On this employee's machine I have a rule in > Outlook that moves all emails from their client with a specific subject into > a subfolder in Outlook. > > I then have an instance of Outlook running in the database (Withevents). > The database thus gets an event anytime an email comes into that > subdirectory. The event sink grabs every message in the subfolder and saves > the attachments into a working directory on the server, then copies the > email into a sub-sub folder so it isn't processed again. The attachements > are two text files and an excel spreadsheet. The text files are imported > using an import spec, and the spreadsheet is imported using append queries, > linking the spreadsheet to a known name. > > This all works very well. > > However we are moving this kind of process onto a server where it will run > continuously. We will no longer have to worry about keeping his workstation > turned on, power failures, his going on vacation etc. > > The client has asked me if he needs to have Outlook running on the server or > if I can pull the emails out of Exchange Server directly. > > Can I? > > John W. Colby > www.colbyconsulting.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com