Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read only tables...is it possible? (2003)

    Is it possible to have an .mdb with linked tables where the users can not modify the data?
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Read only tables...is it possible? (2003)

    You'd have to apply user-level security - see WendellB's tutorial The Secrets of Security. (Note: user-level security is being phased out by Microsoft, it is not supported any more in the new .accdb format in Access 2007).

    If you just want to prevent users from modifying data by accident, you can make all forms in the frontend database read-only (by setting the Recordset property to Snapshot), and hide the database window so that users don't see tables and queries directly. This is not robust, though.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read only tables...is it possible? (2003)

    Hmmm...I'm not interested in doing the security thing and there are no forms, just tables.

    Thanks for the info on security, though. I've never really known much about it.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Read only tables...is it possible? (2003)

    Access does not have any way to protect tables, except for user-level security.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read only tables...is it possible? (2003)

    Donít know what you are tryng to accomplish, for something quick an dirty, you may want to set up some noupdatable queries, example follows:

    <pre>SELECT [CustomerID] & "" AS CID,
    [CompanyName] & "" AS [Company Name],
    [ContactName] & "" AS [Contact Name],
    [ContactTitle] & "" AS [Contact Title]
    FROM Customers;
    </pre>


    HTH, John

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Read only tables...is it possible? (2003)

    You could hide the tables but this is not robust either.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Read only tables...is it possible? (2003)

    Abraxus wrote "there are no forms, just tables", so hiding the tables wouldn't leave much...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •