On Sunday, January 29, 2012 2:27:07 pm gvim wrote:
> I want to use MS Access 2007 as a front end to a more robust/FOSS database.
> Which is more compatible - MySQL or PostgreSQL? Unbiased answers please
> :-).
Honestly the compatibility probably has more to do with the Access/ODBC end of
things then the backend db. I use Access with the Postgres ODBC driver and it
works. I have not used MySQL with Access so can not speak to that. The primary
issue that I have faced, also reported by others, is that once you get past
simple queries you will probably need to use the Pass-Through Query option in
Access. I would imagine this is the same for MySQL as it is for Postgres. The
reason for this is that the syntax Access uses in building complex queries is
not all that standard and will often fail on a non-Access backend(assuming one
considers the ACCESS JET db engine a backend) The Pass-Through offers you the
ability to construct server specific queries that get passed to the server
directly.
>
> gvim
--
Adrian Klaver
adrian.klaver@gmail.com