Read only - linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
dejaqhsa said:
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
Click to expand...

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'
 
yes, via tools / security / user & Groups permissions

Pieter

dejaqhsa said:
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
Click to expand...



--
 
Back
Top