Access query changes

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

Guest

When did Access 2003 allow changes to be typed into a query that subsequently
change the table that they were based upon? This is a very dangerous change
to how a database should work. You should never be able to affect the
original table exceopt directly. Does anyone know if this was by design or an
oversight? Is this a problem for others? What are the chances of going back
to teh way it was. I will consider using a different database as this change
allows too much room for orignial data to be changed improperly.
 
akfish said:
When did Access 2003 allow changes to be typed into a query that
subsequently
change the table that they were based upon? This is a very dangerous
change
to how a database should work. You should never be able to affect the
original table exceopt directly. Does anyone know if this was by design or
an
oversight? Is this a problem for others? What are the chances of going
back
to teh way it was. I will consider using a different database as this
change
allows too much room for orignial data to be changed improperly.
Click to expand...

As long as a query is updatable, all versions of Access allow you to change
the data displayed by them.

Tom Lake
 
In Design Mode -> Property, set the Recordset Type to Snapshot (I don't know
if you can do this with all kinds of queries).

For a more secure environment, the datas should be accessible only through
Forms and you should implement the security features of Access.

S. L.
 
Thanks this may help me although having to set this for each query is not
very efficient. I agree that using the forms is a good solution.

in the past you could not go in to a queries spreadsheet and change cells. I
have found that when people are designing queries that accidental changes are
made to the spreadsheet. This now affects the original table leading to
potential errors in original data sets while queries are being built to make
forms.

Thanks again.
 
Yes but in the past you needed to update a table with an update query. This
forced you to be aware of the changes you were making. Now in spreadsheet
view you can accidentally change a cell in a query that will change the
original cell in the table. This means data can be compromised when the query
building is taking place...

Thanks for the reply...
 
Yes, you could go into any query that was updatable and change the data in the
"spreadsheet" view. Access has done this in all versions that I know of. Are
you talking about this being the case if you are hooked to some other source of
data than a standard Access (Jet) table?
 
Back
Top