How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30137
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

We use MS Access (via ODBC connections) to run queries against

This answer was rated:

We use MS Access (via ODBC connections) to run queries against production tables in a warehouse management system. How can you make the ODBC connection READ ONLY, so that a user doesn't accidentally update a production table?
Thank you for your question, my name is Richard.

You need to split the database to do this, and give the USER a read only copy. It cannot just be done via ODBC

SO make a copy of the DB, and in this copy, remove the Tables

Then do the following

In the source database, create a query based on the required table. Select all of the fields you wish to be visible to the user, including the primary key field (this is essential)

Group By all fields.

Save the Query.

In your client database (used by the user) create another query

Similar to

FROM qryData IN 'S:\Backend.mdb';

Where qryData is the name of the query created in the source database
and 'S:\Backend.mdb' is the path to the database.

When you open the local query in the client, you should see all records but not be able to edit them.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Richard and 4 other Microsoft Office Specialists are ready to help you