I have created Access database as a frontend application and another database as a Backend Database (all the databases are password protected). All tables and queries are stored in Backend Database.
My problem is that I need to create a form (Combo filters) with sub-form (List of the columns). I don't know how to show the data in this form / sub-form from backend database, I really need someone help for this.
Please let me know if someone has sample code for the same.
Any idea how to show backend data in frontend application.
I have two databases FE and BE. And BE database is password protected. I need to extract data from BE database and need to show in FE in read only format and need to provide one button to change the data.
Any idea how to achieve that. Please let me know if someone has sample code for the same.