Forum Discussion

Pieceguy's avatar
Pieceguy
Copper Contributor
May 05, 2025

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 ...
access
office 365
arnel_gp's avatar
arnel_gp
Iron Contributor
May 06, 2025

make sure you use forms and reports on displaying your data.

you assign the RecordSource of the forms/Reports on the Load event, eg:

For report

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = "SELECT * FROM (SELECT * FROM [" & BEPath & "\BEName.accdb;PWD=BEpassword].yourTableName);"
End Sub

for form:

Private Sub Form_Load()
Me.RecordSource = "SELECT * FROM (SELECT * FROM [" & BEPath & "\BEName.accdb;PWD=BEpassword].yourTableName);"
End Sub

therefore, you can delete the queries and Linked tables from your Front End.

Resources