Topic: Mandatory Keys incorrectly configured - how to fix?
[programs / versions / Log File]
GeniusConnect V5 Outlook 2003
Version:501101 Multi-Byte 32 bit build.
Edition:5, Outlook version support: 2000 or higher.
Microsoft® Office Outlook® 2003 (11.0.0.8330) 32bit
Microsoft® Office Access® 2003
...Beginning of Log file
INFO:20130130 16:15:39 Folder: \\Personal Folders\Contacts\companies
INFO:20130130 16:15:39 Connecting to database: MS Access Database
INFO:20130130 16:15:40 Connected to database
INFO:20130130 16:15:40 Using file storage:C:\Users\Win7(Edward)\Documents\GeniusConnect\companies1.gc
INFO:20130130 16:15:40 Saving all Outlook items to database...
INFO:20130130 16:15:40 Preparing to save items
ERROR:20130130 16:15:41 Database call:
select max(id) + 1 from companies
07001 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (-3010)
WARNING:20130130 16:15:41 Advanced-Resources Temp-Agencies Items has empty primary key(s)!Without primary keys it is not possible to find the item in the database.
INFO:20130130 16:15:41 Inserted: Advanced-Resources Temp-Agencies
ERROR:20130130 16:15:41 Database call:
select max(id) + 1 from companies
07001 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (-3010)
WARNING:20130130 16:15:42 Expresscdl. com Truckdrivingschool Items has empty primary key(s)!Without primary keys it is not possible to find the item in the database.
INFO:20130130 16:15:42 Inserted: Expresscdl. com Truckdrivingschool
INFO:20130130 16:15:42 Summary:
INFO:20130130 16:15:42 -> Successfully saved 10 items(0 updated, 10 inserted, 0 unchanged, 0 conflict(s))
INFO:20130130 16:15:42 Disconnecting from database
INFO:20130130 16:15:42 Disconnected from database. Time Elapsed:0 min. 2 sec. Start:01/30/13 16:15:40 End:01/30/13 16:15:42 Items:10 Items/second:5
.... End of Log File