Hi All,
I am currently working on securing an access application.
I have split the database and applied a password to the back-end. I have already re-linked back the tables on the front end.
However, the issue is that, despite the back-end being password protected, I am still able to retrieve the tables by creating a new access > export tables from FE.
I would like to prevent the encrypted tables from being retrieved. One way to do it, from what I have gathered, is to delete the link on exit and re-link on opening.
Is there any way to script so that the re-link and deleting link will happen automatically?
Please kindly advise!
(I have to link the tables automatically as I do not want my users to have the password. At the same time, my app cannot run without the tables being linked)
I am currently working on securing an access application.
I have split the database and applied a password to the back-end. I have already re-linked back the tables on the front end.
However, the issue is that, despite the back-end being password protected, I am still able to retrieve the tables by creating a new access > export tables from FE.
I would like to prevent the encrypted tables from being retrieved. One way to do it, from what I have gathered, is to delete the link on exit and re-link on opening.
Is there any way to script so that the re-link and deleting link will happen automatically?

Please kindly advise!
(I have to link the tables automatically as I do not want my users to have the password. At the same time, my app cannot run without the tables being linked)