Hi Guys,
I have split database and in FE user has query with all records.
I did in Excel pivot table with source to my Access Database.
Problem is that every user can create connection to Access Database without any passwords and problems.
I want to give access only to administrator in order to create pivot table like that.
It is possible?
Or best idea is to secure Access database inside it ? So give permission to administrator and button to export Excel file ?
Best wishes and thank you for help,
Jacek