Post reply

Restrict Sql Server access from MS Access

  • March 2, 2007 at 8:54 am

    #76668

    Is there a way to block all connections to a sql server DB from MS Access?  Or better, can we make all rights read only when the connection comes from ms access?

     

    Thanks,

    Steve

  • March 4, 2007 at 4:01 pm

    #693012

    IIRC It's more a case of ODBC rights, and how they're set up, which would affect the connectivity of any application using said ODBC settings...

    There may be an option in there to make the ODBC connection readonly, have a look.

    The other option that may work is to put a load of linked tables into a database, make that a read only database (permissions) then have your other databases access that. Not sure that'll work, but it might and is an easy solution if it does - what's more you'll have control over what tables are seen too.

    You could also make a view inside your SQL database and link to that?

     

    Cheers,

    Andrew

  • March 7, 2007 at 12:12 pm

    #693640

    Hi..!!!

    Maybe you can make the ODBC uses an SQL Server "User_id" with read rights only, then the linked tables on access will read data but it could not write back.

    I have not tested this, I'm using an Access data base linked to an SQL Server to modify information, but the only tables i saw are the ones that my user_id is able to update on the server.

    I Hope this help you.

     

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

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