Hello,
I have a question on how to make my tables hidden from excel imports.
My situation:
I have a front end accde for the users that is not protected with a password. I have a script that checks the windows username and if its not in the backend it will close the database.
The backend is password protected.
I have hidden my tables even when i open the front end and then show the navigation pane. Even when i click show hidden tables.
The only problem is when i open a new excel file. Then i go to the data tab. Press new query then from database then from microsoft access database.
Then i go and select the front end. There i can see every linked table and import this into excel.
Is there a way to prevent this? I have searched all my books and i have searched for a while on the internet but i cannot seem to find a sollution anywhere.
I hope someone will be able to help.
Sorry for my bad english. Its not my native language.
I have a question on how to make my tables hidden from excel imports.
My situation:
I have a front end accde for the users that is not protected with a password. I have a script that checks the windows username and if its not in the backend it will close the database.
The backend is password protected.
I have hidden my tables even when i open the front end and then show the navigation pane. Even when i click show hidden tables.
The only problem is when i open a new excel file. Then i go to the data tab. Press new query then from database then from microsoft access database.
Then i go and select the front end. There i can see every linked table and import this into excel.
Is there a way to prevent this? I have searched all my books and i have searched for a while on the internet but i cannot seem to find a sollution anywhere.
I hope someone will be able to help.
Sorry for my bad english. Its not my native language.