Read Only Query

[FeS2]

I have Access 2003. I have a simple database with 1 table. I need to provide access to other users, which really isn't the problem. I want them to access information using only 1 query that asks for a parameter they will supply. However, it lets them delete information from the database. I need to make this query a read only query so that they can not change the records. I have other users that update data all the time so they still need full access. I know union queries do that but I have only 1 table and no plans to add another table. Can this be done without using logons and permissions? Any help would be appreciated.

 

[PHV]

You may simply add the DISTINCT predicate in your SQL code to make the query read only:
SELECT DISTINCT field1, ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[FeS2]

Thanks so much, that worked perfect.