I have downloaded the Genius Connect software for evaluation. I need to assess its capabilities for backing up Outlook Contacts.

Having configured the neccessary blank MDB with a table a the approriate fields and configuring the Primary Key SQL Statement I get the following error when I try to Store Items

37000 [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (-3502) (SyncFolder)

Do you have any suggestions/solutions

Regards

check the following:
-do not use space in column/table name ("ColumnID" not "Column ID")
or check the "ANSI quoted identifiers" checkbox

I haven't any spaces in either the column or table names - what about other characters - I have used () brackets

() can be also a problem.
Please, try also the example mdb see:
http://support.geniusconnect.com/Posts/t16- 

All working now - thanks

I have just recently had a similar problem. I have been using this software for a number of weeks and has been working ok.

However, yesterday, I am now also receiving a similar 37000 error.

The only changes I have since it last worked are : a) re-installed Activesync 3.7.1 , b) installed the latest version 1.0.2.7

I have removed and re-installed, but still getting errors. I have also noticed that using an ODBC link from an MS Access database onto the MYSQL database, on Linux, that I can only perfom query and not update.

Any ideas on how this problem was previously resolved.

Please see:
http://support.geniusconnect.com/Posts/t98- 
(to disable ANSI SQL generation)