Linking Access DB to PostgreSQL backend from individual PCs
Posted on 2012-03-21
I am developing an Access 2007 database (front end) with a PostgreSQL backend for a software development team. Each team member has a stand alone version of the postgres database running on their machine that contain all the data tables. They just need a front end GUI to easily change/enter data in those tables as they generate/test code.
On my PC, I have imported/linked the tables from the Postgres db and am building a GUI interface in Access. My question is....when I load the Access database on each team member's PC, do I need to re-import those tables? And if so, will my GUIs work or do I have to relink those to the imported tables as well?
I hope I have provided enough information.