Query Table

**hitesh_asrani_j** · 10-24-2011, 08:08 AM

Hi All,

I have a query which searched for an order number from a table and gives a result.

Is it possible to make sure that the table which comes as a result is read only..

**Stingaway** · 10-24-2011, 08:16 AM

In the properties of your query, set the Recordset type to Snapshot instead of Dynaset.

**hitesh_asrani_j** · 10-24-2011, 08:27 AM

Thanks a lot u solved a big problem

Query Table

Thread Tools

Query Table

Similar Threads

Query to Concatenate multiple fields between a table and a sub table to 1 line

Insert query into table FROM two table sources

query to select table based on another table feild value

Table form with records from a query to insert results in a different table

How to make query based on external access DB's table and the table in linked table?

Posting Permissions