When I run "Load All", all the contacts are updated, 0 are unchanged, even thought the source MySql data hasn't changed.

Regards

Martin

possible cause:
-datetime field linked to smalldatetime field or other fieldtype whitch is to small to hold full datetime
-Outlook can change first character of Middle name, Initials etc. to Uppercase. (database value: "van" Outlook: "Van")
-Outlook can add space character to the end of a phone number
-Outlook can remove spaces from phone numbers.(Database value "+31 20 4565423" Outlook: "+31204565423")
-a field is to small to hold whole value, compare during set/get operation will always differ
-Outlook can change formatting of Full Name, Full Address etc. (Upper/Lower case, spaces.)
-Outlook can change values of columns like Owner, LastModifiedTime etc.

-Outlook can reset value of ReminderOverrideDefault column in Calendars

I have just updated to the latest release due to a system rebuild. I have noticed all contacts are updated again. This time I have tracked the problem down to the Categories. I am just loading data from my database into outlook.
A category field of 'test' (without the '') shows items as unchanged.
A category field of 'test;test1' (without the '') shows items as changed.

I am using Mysql through ODBC, and outlook 2003.

Any ideas gratefully received.

Regards

Martin

Outlook accepts 'test;test1' but will reformat it as 'test; test1' (space between ; and test1), so next load will differ