Read only - linked table

[Guest]

Hi
Huge thanks to anyone who can help.

Is it possible to make a linked table "read-only"?

So that when you go in the original table it is ok and you can make changes,
but when you access the table via a link it is read only?

Cheers
Dejaqhsa

 

[Rick Brandt]

Hi
Huge thanks to anyone who can help.

Is it possible to make a linked table "read-only"?

So that when you go in the original table it is ok and you can make
changes, but when you access the table via a link it is read only?

Cheers
Dejaqhsa

You could create a query that pulls in the data from the table instead of
using a link. Then you can make the query read only by setting the
RecordSetType to Snapshot. You would use the IN clause to reference the
remote table...

SELECT * FROM TableName IN 'Path to other MDB File'

 

[Pieter Wijnen]

yes, via tools / security / user & Groups permissions

Pieter

 

[Pieter Wijnen]

yes, via tools / security / user & Groups permissions

Pieter

Hi
Huge thanks to anyone who can help.

Is it possible to make a linked table "read-only"?

So that when you go in the original table it is ok and you can make
changes,
but when you access the table via a link it is read only?

Cheers
Dejaqhsa

--