View Full Version : Select query altering table information


ConfusedA
08-31-2009, 11:45 AM
I have a select query, and if I accidentally alter information within it's results it automatically alters that record in my table. Is there a way to stop this?
ConfusedA

pbaldy
08-31-2009, 11:54 AM
I wouldn't let users into a query directly, but you can change the Recordset Type to Snapshot in the query's properties.