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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
