Form based on snapshot query has editable fields?

R

Richard

Built a snapshot query and a form using the query as the record
source.

The form lets me edit the underlying data. Why would that be ?
In other words, why doesn't the forms recordset type inherit from the
record sources recordset type?

Also, does one make a table read-only?
 
J

Jeff Boyce

Richard

In my copy of Access, if I open a query in design view, select the
Properties, and set Recordset Type to Snapshot, according to Access HELP, I
get a recordset that is NOT update-able.

Is this what you are doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

Richard

Richard

In my copy of Access, if I open a query in design view, select the
Properties, and set Recordset Type to Snapshot, according to Access HELP, I
get a recordset that is NOT update-able.

Is this what you are doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

Hi Jeff:

Yup, Properties window in query design used to set query RecordSetType
to snapshot.

When query is opened, the data is read-only -- as expected.

However, when query is used as RecordSource in a new form (wizard),
the data is editable (forms RecordSetType is Dynaset when form first
built) -- contrary to my expectations.
 
J

Jeff Boyce

Contrary to mine, too. I'll take another look (and, I suspect, so will many
others!).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

Richard

I created a query, set its RecordSet Property to Snapshot. I could not edit
the fields the query returned.

I created an AutoForm, based on that query. Contrary to what I would have
expected (and apparently what you found, too), the form gave me an
update-able recordset, even though it was based on the non-update-able
query.

When I changed the form's Record Set property from Dynaset to Snapshot, the
form became "read-only" and could not be used to update data.

I'm with you! Why would Access think that a form based on an un-update-able
query should somehow (?magically) become update-able?!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top