How can I contruct a "READ ONLY" query

[Guest]

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

 

[Nikos Yannacopoulos]

No, you cannot have a "read-only" query, but you can have a "read-only"
form. Open the form in design view, select the form and change the following
properties (on the Data tab):

Allow Edits
Allow Additions
Allow Deletions

from Yes to No.

HTH,
Nikos

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]

In query design view, change the Recordset Type property of the query to
Snapshot.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

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

 

[Rick Brandt]

No, you cannot have a "read-only" query, [snip]

Actually you can in several ways. Setting the RecordSet type to Snapshot
is the easiest way, but there are several others.

 

[Brendan Reynolds]

No, it means that you will not be able to type anything in any bound
controls on the form. If you want to be able to edit the contents of a
control but not have those edits saved, then use an unbound control or an
unbound form.

It's quite rare that you would want to do this with a form that displays
data, however. Mostly, if you're not going to save the changes, there's no
point in letting the user make the changes, as that would be just a waste of
the user's time.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

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?