Read-only when attaching in the external database?

K

Kenw

In running a query on an external database I would like
to be sure that I don't accidentally change the data in
the database. Is there a way that I can view only the
external database in read-only mode so that I don't
accidentally change it?
 
J

Joan Wild

Kenw said:
In running a query on an external database I would like
to be sure that I don't accidentally change the data in
the database. Is there a way that I can view only the
external database in read-only mode so that I don't
accidentally change it?
Click to expand...

You could open your query in design view and look at the properties. Change
the Recordset Type to snapshot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove external organization from Office. 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Reading view 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel file linked to external source 0
need help ASAP word 2016 recipient cant edit 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Merging from an Excel file with graphics 1

Top