Altenburg, Tim
2006-02-06T16:46:00Z
I maintain appointments in an MS Access 2003 table with seperate fields for the Date and Time.

In MS Outlook 2003, these fields are combined in the Start field.

I have tried to concatenate these Access fields in a query prior to sync but this does not work.

Can you offer advice on how I may be able to sync Outlook and Access appointments and maintain seperate fields for Date and Time in Access.
Administrator
2006-02-06T18:35:00Z
Hello,

You have to create a VIEW (query in MS Access) to concatenate the fields.
The problem is: MS Access does not support VIEW triggers, so you will not be able to Store items, only Load to Outlook.

To solve this you have to switch to MS SQL Server (support for instead of triggers).
In the instead of triggers you can split the fields back to the real fields and table.