Guus2005 AWF VIP Local time Today, 03:04 Joined Jun 26, 2007 Messages 2,642 Apr 24, 2008 #1 I have a database with sensitive data. I dont want users to change the data, so i used a snapshot query. However when i use this query in another query, the result is an updateable query. Is there a way around this? Attachments db15.zip db15.zip 8.7 KB · Views: 87
I have a database with sensitive data. I dont want users to change the data, so i used a snapshot query. However when i use this query in another query, the result is an updateable query. Is there a way around this?
N namliam The Mailman - AWF VIP Local time Today, 03:04 Joined Aug 11, 2003 Messages 11,695 Apr 24, 2008 #2 Group by queries are not alterable, Or you can stick your query on a form and make the form "un alterable" by changing the "allow edits" to no...
Group by queries are not alterable, Or you can stick your query on a form and make the form "un alterable" by changing the "allow edits" to no...
Guus2005 AWF VIP Local time Today, 03:04 Joined Jun 26, 2007 Messages 2,642 Apr 24, 2008 #3 That's an idea! Thanks.