C ConfusedA Registered User. Local time Today, 08:53 Joined Jun 15, 2009 Messages 101 Aug 31, 2009 #1 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
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 Wino Moderator Staff member Local time Today, 05:53 Joined Aug 30, 2003 Messages 36,272 Aug 31, 2009 #2 I wouldn't let users into a query directly, but you can change the Recordset Type to Snapshot in the query's properties.
I wouldn't let users into a query directly, but you can change the Recordset Type to Snapshot in the query's properties.
