Forum Discussion
Pieceguy
May 05, 2025Copper Contributor
Block users from exporting queries and tables
First off apologies very new to access and databases in general, but I am having an issue where users can just grab my queries/tables out of my access database with excel. I'd like to know how I can ...
May 06, 2025
Hi,
George already wrote that there are only limited means if you use an Access backend.
> encrypted the back end
If you have used a database password for the backend file then there is no "free pass" anymore to the data. A user who tries to connect from Excel to the data in the backend will be asked for the database password.
To exclude external intruders you have to close the file chain as described in our beautiful video here.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK