Postgres *will* work with access
I do it daily.
Use either the ODBC driver or grab the win32 postgres driver. (google it out)
Install it on to the computer with Access, either as a user store or machine store, depending on whether you just want your user to have access to postgres databases or any user.
Now set it up. Make sure Postgres is running with -i (allow inet connections) and that you give some kind of access in pg_hba.conf. There are man pages and examples in the file to follow.
On the Win32 side, make sure that you UNCHECK read-only (there are two checkboxes for this in different tabs. Why I have no clue) - now give the IP and user info and database info.
When all of that is done you create a new database in Access (just a blank one) and then File/Get External Data. You can either link it or copy it. I suggest linking, because if you copy you will now have two copies of the data on Postgres: one in Postgres and one in Access and they will NOT synchronize.
Nothing to it. Have fun.