| | |
|
|
|
How can I contruct a "READ ONLY" query |
|---|
| message from =?Utf-8?B?V0MgTG8=?= on 3 Jun 2004 |
I have a form with a query. Usually when the form is close or change of record, the query will update the database. is it possible to build a read-only query? thanks
|
| Brendan Reynolds replied to =?Utf-8?B?V0MgTG8=?= on 3 Jun 2004 |
In query design view, change the Recordset Type property of the query to
Snapshot.
|
| =?Utf-8?B?V0MgTE8=?= replied to Brendan Reynolds on 3 Jun 2004 |
Thanks guys. Does it mean what ever I type in the form will not update the recordset and the recordset will not update the table?
|
| Nikos Yannacopoulos replied to =?Utf-8?B?V0MgTG8=?= on 3 Jun 2004 |
No, you cannot have a "read-only" query, but you can have a "read-only"
Allow Edits
Allow Additions
Allow Deletions
from Yes to No.
HTH,
Nikos
"WC Lo" <anonymous@discussions.microsoft.com> wrote in message
news:5506A34D-1934-4EE3-97DD-F1EA7634C389@microsoft.com...
record, the query will update the database. is it possible to build a
read-only query? thanks
|
| Rick Brandt replied to Nikos Yannacopoulos on 3 Jun 2004 |
Actually you can in several ways. Setting the RecordSet type to Snapshot
is the easiest way, but there are several others.
|
|
Archived message: How can I contruct a "READ ONLY" query (Microsoft Access Database)
