Lookup table data from Access database is scrambled
This is a bug in the OLEDB database driver used to communicate with Access. The data is received by Sync & Save in the scrambled format.
There are two possible solutions to this problem:
- Do not use multi value fields for data you wish to use in Sync & Save.
- Connect to Access using ODBC.
Multiple values in a field will be returned as values separated by a semi-colon.
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;
Change the path to the database to match your configuration.