how to connect it to local Access DB - Event Date: 22 Nov 2005 - 23 Nov 2005

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   Hi, I want to make a simple db to record my email locally, not via SQL. How to do that. 

Thanks.

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
insidecomputer Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 18 Nov 2005 Posts: 8	Post Options Post Reply Quote insidecomputer Report Post Quote Reply Calendar Event: how to connect it to local Access DB Posted: 22 Nov 2005 at 6:07am
	Hi, I want to make a simple db to record my email locally, not via SQL. How to do that. Thanks.

Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1392	Post Options Post Reply Quote Stephen Report Post Quote Reply Posted: 22 Nov 2005 at 4:54pm
	Hi, The easiest way is to use MS Access. Create a new Access DB in say C:\Emails\ Create a new table called 'EmailBackup' and create the fields: From - Text(250) To - Text(250) Subject - Text(250) Body - Memo Dated - Date Save the Access Database - call it 'Email2DB.MDB' Then create the trigger in Email2DB. Create the fields: 'From' - extract built-in field %MSG_From% 'To' - extract the built-in field %MSG_To% 'Subject' - extract the built-in field %MSG_Subject% 'Body' - extract the built-in field %MSG_Body' 'Dated' - extract the build-in field %MSG_Date% - set the field type to Date/Time Set the table name for each field to 'EmailBackup' In the Update Database section of the trigger. Click the Build button next to the Connection string and select 'Microsoft Jet 4.0 OLE DB Provider', then select the C:\Emails\Email2DB.MDB file. Click Ok to save the connection string. Email2DB will then update this database with any emails for this trigger. Thanks Steve

insidecomputer Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 18 Nov 2005 Posts: 8	Post Options Post Reply Quote insidecomputer Report Post Quote Reply Posted: 22 Nov 2005 at 5:06pm
	Thank you! I will try it and let you know.

insidecomputer Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 18 Nov 2005 Posts: 8	Post Options Post Reply Quote insidecomputer Report Post Quote Reply Posted: 23 Nov 2005 at 5:44am
	It works. At least for the first few steps now. My next questions are: 1, Like many web based email, such as yahoomail, it has its own filters which pre-routes emails before it hits inbox. Is there anyway to get arround with this without changing filter setting. In another word, can we read folders other than inbox? 2, how do I setup a time range which I want email2db to read from my pop3 server. You have read since setting. I don't see since till setting. Thanks

insidecomputer Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 18 Nov 2005 Posts: 8	Post Options Post Reply Quote insidecomputer Report Post Quote Reply Posted: 23 Nov 2005 at 8:22am
	Some From filed are empty. Error: 12147217887 The field is too small... I checked, it was set to 250 as you suggested. Also, trigger seems stops after about an hour of running. Why is that? But the program is still reading from remote pop3 server. If I click on "Clear Checked Messages Database", it will restart from beginning again. My database will be updated twice.

Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1392	Post Options Post Reply Quote Stephen Report Post Quote Reply Posted: 23 Nov 2005 at 9:22am
	Hi, For the 'field is too small' error you need to set the 'Maximum Field Size' on the Email2DB fields to match your DB field sizes (Email2DB will then truncate the data before updating your database) or increase the size of your database fields. The example of '250' was just an example and not meant to match your exact needs. For the POP3 issue.. we recently increased the timeout value for the POP3 option as this could sometimes cause Email2DB to give up retrieving POP3 emails. Please download the latest build from: http://www.parkersoft.co.uk/downloads/em2dbsp16.exe Let me know via email at support@parkersoft.co.uk if the problem persists. Thanks Steve