Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Read only - linked table

Discussion in 'Information Technology' started by dejaqhsa, Jul 28, 2006.

Tags:
  1. dejaqhsa

    dejaqhsa
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    Literature Has Anyone Read: "The Sikh Religion: Its Gurus, Sacred Writings And Authors" Language, Arts & Culture Oct 22, 2016
    Does Reading Baani Magically Affect Our Body And Psyche? And Does The Effect Depend On The Bani Read Intellectual Translations by SPNers Apr 30, 2016
    Sikhi Am I Ready To Take Amrit? Sikh Sikhi Sikhism Mar 10, 2016
    Emphasis When Reading Gurbani Intellectual Translations by SPNers Feb 14, 2016
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    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
    > 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
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    yes, via tools / security / user & Groups permissions

    Pieter

    "dejaqhsa" <dejaqhsa@discussions.microsoft.com> 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
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    yes, via tools / security / user & Groups permissions

    Pieter

    "dejaqhsa" <dejaqhsa@discussions.microsoft.com> 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
    >




    --
    ----------------------------------------
    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.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page