- Joined
- Feb 26, 2013
- Messages
- 12
- Reaction score
- 0
Hey All
I have written 3 queries in Access
2 queries are based on criteria (that the user will type in)
1 query queries all columns from a table within the database (user needs access to all information and opening the database up in administrator mode for that user is too risky)
Both queries with a parameter query within them are fine, and the user cannot change the information that the query brings back.
However, with the last query, I have found that the user is able to change the data (even though it is a query)
Why would this be and how would I prevent this from happening?
Thanks all for taking the time to read this
I have written 3 queries in Access
2 queries are based on criteria (that the user will type in)
1 query queries all columns from a table within the database (user needs access to all information and opening the database up in administrator mode for that user is too risky)
Both queries with a parameter query within them are fine, and the user cannot change the information that the query brings back.
However, with the last query, I have found that the user is able to change the data (even though it is a query)
Why would this be and how would I prevent this from happening?
Thanks all for taking the time to read this