Make an ODBC connection to SQL read only on the Acces side- possible?

Posted on 2007-07-23
Last Modified: 2008-01-09
Using ODBC, I am connecting to a SQL server table in our main business system.  Is there any way that I can make this connection read only?  I noticed that it is possible to make changes directly in the table.  Users don't work in tables, but it still makes me leery and I would like to lock it down some how.
Question by:snyperj
    LVL 92

    Expert Comment

    by:Patrick Matthews
    I would set up a user profile in SQL Server that has read-only rights, and then use that
    user profile to establish the connection.
    LVL 44

    Expert Comment

    So there's no changing anything, not even via forms?

    Author Comment

    right- is all lookup- comparing estimates to what was actually billed, if you will....
    LVL 44

    Expert Comment

    Well then I think Patrick nailed it.
    LVL 13

    Accepted Solution

    you could use pass thru queries as the data source for your forms. pass-thru queries are read only.

    Create a new query in design view. From the Query menu, select SQL specific, Pass-Thru query. Go to query-Properties and change the connection string (if you need help with this, let us know) Then write your query in sql view. save your query and use it as the data source for your form and the users will be unable to update the data.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now