How can I contruct a "READ ONLY" query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

WC Lo said:
I have a form with a query. Usually when the form is close or change of
Click to expand...
record, the query will update the database. is it possible to build a
read-only query? thanks
 
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.


WC Lo said:
I have a form with a query. Usually when the form is close or change of
Click to expand...
record, the query will update the database. is it possible to build a
read-only query? thanks
 
Nikos Yannacopoulos said:
No, you cannot have a "read-only" query, [snip]
Click to expand...

Actually you can in several ways. Setting the RecordSet type to Snapshot
is the easiest way, but there are several others.
 
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.


WC LO said:
Thanks guys. Does it mean what ever I type in the form will not update
Click to expand...
the recordset and the recordset will not update the table?
 
Back
Top