MySQL View in Access has wrong data types
I have a application with MS Access frontend and a MySQL Database as backend.
To speed up some queries i created a View in MySQL and linked it in Access.
Access changed the datatype of all varchar fields to binary or OLE-Object.
So instead of my data i receive chinese symbols and "long binary data" as values.
All tables of the view are linked in Access, without any problems.
Only the View won’t give me any readable data.
I have no idea how to get Access to keep the data types of the view. Like it dose with the tables.
