How to lock linked table (1 Viewer)

[Ossama22]

Hello Guys,
I have an inquiry and i hope that anyone can help me,
I have a database and i import another database file as a(linked table),
My question is there anway to protect or lock the linked table only (in another way to be read only data)

Thanks in advance

 

[theDBguy]

It depends. What is the source of the other database table? Certain data sources are typically read only when you link to them in Access.

 

[kevlray]

The easy way if you have a linked table in MS-SQL is not to have a primary key.

 

[Ossama22]

Could you tell me what u mean by linked with MS SQL?

 

[The_Doc_Man]

MS SQL usually refers to "SQL Server" as a back-end system to host database files.

The way to protect the external data is to never let users see it directly. From the way you are asking this question, I wonder if you perhaps did not hide the database window from your users? You can look up the topic of "securing a database" to find out ways to protect your content. It takes a bit of work but you can protect your stuff pretty well, at least from casual damage.