[ADMIN] Storing images and other data in PostgreSQL from Ms Access

Hi All, I am testing the postgresql as a back-end for a project having ms access as a front-end. I have linked postgresql tables and started using. It works well for all data except the binary data. When used to insert/retrieve data from such fields, ms access gives error that it can't recognize th

Re: [ADMIN] Storing images and other data in PostgreSQL from Ms Access

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 *IIRC*, using bytea type works like a charm for OLE stuff from MS Access... Try to link your tables with the ANSI driver, then change the ODBC source to the UNICODE one. I don't know why, but ISTM that MSAccess perform a better type mapping with the A