Read only - linked table

Hi
Huge thanks to anyone who can help.

Is it possible to make a linked table "read-only"?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13374-read-only-linked-table.html

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


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

dejaqhsa wrote:
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13374
> 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'

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

yes, via tools / security / user & Groups permissions

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13374
Pieter

"dejaqhsa" wrote in message
news:0B63B778-8699-48F8-8FB0-CD94F905123D@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13374
>

yes, via tools / security / user & Groups permissions

Pieter

"dejaqhsa" wrote in message
news:0B63B778-8699-48F8-8FB0-CD94F905123D@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13374
> changes,
> but when you access the table via a link it is read only?
>
> Cheers
> Dejaqhsa
>



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13374
Get the free SPAMfighter here: http://www.spamfighter.com/len