Read-only when attaching in the external database?

  • Thread starter Thread starter Kenw
  • Start date Start date
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?
 
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.
 
Back
Top