Result of subquery based on Snapshot query is not readonly (1 Viewer)

Guus2005

AWF VIP

Local time

Today, 15:02

Joined

Jun 26, 2007

Messages

2,645

• 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

  8.7 KB · Views: 84

N

namliam

The Mailman - AWF VIP

Local time

Today, 15:02

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...

 

Guus2005

AWF VIP

Local time

Today, 15:02

Joined

Jun 26, 2007

Messages

2,645

• Apr 24, 2008

• #3

That's an idea! Thanks.