I have a PostgreSQL database working as backend and I have to develop an Access frontend solution for regular users of this database.
I decided it best to create some forms to manage the input, delition and deletion of data in the datbases, but as I am somewhat new to Access I may not be righ in my assumption here: if I import tables from the database into Access using the linked-table facility, and if I specify such connection as read-only (I want them to use the forms and the forms alone, least they screw everything up), when using the forms, they would connect to my Access's access of the tables, which is read-only, and thus edition, addition and deletion will not be supported for the form, right?
As I though of this, I also thought of creating a button on the form to change the table it is connected and bound to. Basically, it would open an ODBC connection to the real database and bind the form to the same table, but using different access rights.
Here comes the real question: how viable/useful/helpful/problem-solving is this solution and what VBA elements would I need to use? (I just learned about macros and VBA the last week)