Results 1 to 2 of 2
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Protecting Linked SQL Tables (2000)

    I have some tables in an SQL 2005 database linked to an Access .mdb
    The connection for the links ONLY allows SELECT, NOT Update, Delete or Insert.
    This is set up on the SQL Login that is used for the Connection.
    However, despite this, I can still edit and update the data in the linked tables using Access.
    If I use the same login on SQL directly I cannot.
    Have I missed something here.
    We do NOT want to use Access's own security for this.
    Andrew

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Protecting Linked SQL Tables (2000)

    Still not sure about the tables.
    However, I found a solution...
    I used Views instead of tables and set the Properties of the Views
    to be SELECT only (which was the same as the tables).
    The views are read only (as I expected), but the tables remain editable.
    So I have removed the table links and kept the view links.

    I could I guess also have used pass through queries instead.
    They may have been slightly quicker to retrieve data but have not tested this option.

    Still interested in if the table link option is workable.
    Andrew

Posting Permissions

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