I've a client who is considering using MySQL as a backend to an Access database. I've successfully built several Access databases with MySQL backends. However, I've never needed to store OLE Objects in any of these database.
After some research, I've discovered that MySQL has a LongBLOB data type that is suppose to be able to used similarly to the OLE Object Type data type in Access.
1. Does anyone out there have any experience using MySQL LongBLOB data types?
2. If so, do they act and feel like OLE Data type fields in the Access frontend?
A. Will end users be able to right-click on the field and INSERT an object?
This is very important - as the field needs to be very user friendly in this application.
Thanks in advance for your advice