I do the same thing But in this case it was out of my hands, In order to get the archive up and going I did the Outlook() link from Outlook to access, and it created the schema :-(
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hutch White Sent: Tuesday, July 30, 2002 8:38 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Inserting into MS Access :-( When I design a database, I never can remember all the reserved words or special characters, so I enter a name that makes sense and put an underscore after it and an underscore any place I'm tempted to put a space. That pretty much protects me from myself. Hutch White IT Development Specialist Capital Pacific Homes, Inc. 1717 W. 6th St. , Ste. 140 Austin, TX 78703 Phone : (512)320-8888 Fax : (512)320-0724 Mobile : (512)750-3346 -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:37 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Inserting into MS Access :-( Hi Actually it wasn't the Spaces in the Column Names it was the names themselves. I added a 'W' in front of all the column names and the insert started working. Interesting, so does MS know when it is not one of there products trying to insert into fields named 'To' or 'From' hummmm.... Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm latest beta downloads @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas Ferguson Sent: Monday, July 29, 2002 12:07 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Inserting into MS Access :-( spaces will definitely do it... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Johansen Sent: Monday, July 29, 2002 2:58 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Inserting into MS Access :-( Hi all, Does anyone know the secret to inserting data into MS Access from Witango.. This is for the Archive and the table was created from an Outlook() import from Outlook Column name examples: To text type >From text type Subject text type Has - Attachments Boolean type (yes spaces in the name) Received DateTime type Contents Memo type Is it the spaces in the column names? Is it the Boolean? Is it Reserved words? Should I move the archive to MySQL :-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
