Post reply

Best Practice Security for ODBC Access connection to Sql 2005

  • November 24, 2010 at 5:53 pm

    #241593

    I have an access database published to citrix which can only be accessed by an AD group, the database has a form and several queries but has 2 link tables via an ODBC connection to an SQL 2005 database.

    My question is what is the best way of giving access to the AD group so that they can access the 2 tables and update the data in them?

    Any help would be much appreciated 😀

  • November 25, 2010 at 5:10 am

    #1255534

    can you create a couple of views that selects from each of the linked tables, and then grant the AD group select on the view?

    that's how I've done it in the past, where users hitting my SQL servers needed some data from a linked server;

    if they are connecting to an access db first, i'm not sure my answer is going to help.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply