Uneditable results from query?

[696796]

Hi there,

Can i produce a normal select query that brings up the table of results, but cant be edited? At the moment my query brings up results, but if i click on a field i can edit any data i see, which is a bad thing..
I dont want to export to excel either, as ive already done that.

Its probably really easy but i'm just not too sure

Regards,

Alex Marchant

 

[dhookom]

Is there a reason you are displaying results to a user in datasheet of a query rather than a form? A form has properties to allow editing or not.

One method to make a query readonly is to add a totals subquery as a column.
ReadOnly: (Select Count(*) as ReadOnly FROM AnySmallTable)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[696796]

Well my query has parameters, so im asking for the user to input two dates and then a priority level. I suppose i could output it to a form, (I just did a quick wizard) but i just thought it would give my user quick access to the raw data they require.

 

[PHV]

If you use SELECT DISTINCT then the query is not updatable.

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

 

[dhookom]

696796,
I don't ever expose a query datasheet view in applications. Forms have much more functionality and your parameter query can still be used, with either my suggestion or PHV's.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[696796]

thanks for your responses - decided to go with building forms for the queries, its true, it is more professional

Regards,

Alex

 

[JonFer]

$0.02 - You can set the query type to Snapshot to make it read only with less overhead.