Joel Burton wrote:
Yeah, but with some fairness, setting up a database server and linking the tables from Access can be tricky, as the "average user" can usually no longer make any structural changes (even minor ones) to the tables except through semi-arcane SQL commands or specialized programs specific to that database server. [ MS SQLServer notwithstanding, but of course, then you're into serious $$$]
I was not talking about any database servers. Just linking one access database to another. It's all still in Access.
We use linking to PostgreSQL backend at our org very successfully, but it does limit the ability of my semi-power-users to make structural changes (even minor ones) to our tables. Of course, that might be a *good* thing... ;-)
There do exist GUI tools for Postgres I believe... -- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>