non updateable query

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

i have a form with a command button on it that runs a query. currently the
user can modify the data that is displayed when the query is run which
modifies the underlying table. how can i prevent the user from modifying
data that is displayed in the query.

thanks
 
i have a form with a command button on it that runs a query. currently the
user can modify the data that is displayed when the query is run which
modifies the underlying table. how can i prevent the user from modifying
data that is displayed in the query.

thanks
Click to expand...

DoCmd.OpenQuery "QueryName", , acReadOnly
 
i have a form with a command button on it that runs a query. currently the
user can modify the data that is displayed when the query is run which
modifies the underlying table. how can i prevent the user from modifying
data that is displayed in the query.

thanks
Click to expand...

Open the query in design view; view its Properties; and set the Recordset Type
to Snapshot.

Generally it's best not to let users see query or table datasheets *at all*.
If the users need to see the data in a query, base a Form (with Allow Edits
set to No) on the query and show them the form.

John W. Vinson [MVP]
 
John W. Vinson said:
Open the query in design view; view its Properties; and set the Recordset
Type
to Snapshot.

Generally it's best not to let users see query or table datasheets *at
all*.
If the users need to see the data in a query, base a Form (with Allow
Edits
set to No) on the query and show them the form.
Click to expand...

Or use a report...
 
Back
Top