I've never actually used Access, but I've seen it in the hands of other people being used to access (ha) real databases over SQL*Net (i.e. Oracle). I suspect therefore that it can actually be pointed at any kind of ODBC source, so you could easily enough store the data somewhere safe in Postgres and still give users the whizzy gui thing that they're used to.

This is still not my diary. This is.