Display linked tables in read-only - Disable Error 3027 msgbox

[Elzarie]

Hi,

I have an Access file with several linked tables. This Access file is used by some people. Not all people can open all original files (of linked tables), because they don't have access to the location of the files.
When I disable the connection of a linked table to its original file, i have error 3027 and i can't see the charts or the queries.
If i don't want UPDATE but just display in READ-ONLY the charts and the query, how can i do this ?

I try not to allow all edit/add/delete/enable... properties of the queries and the forms but it doesn't want to display the window as a snapshot or something like this. I want to remove the error 3027 msgbox and go next.
(I understand why error 3027 pop)

thank you for your response

[zmbd]

Look at all of your code and SQL, something is trying to open the links as an editable recordset and/or attempting to modify one of the readonly links... once you find this, you should be able to solve the issue.