Writing to a query

T

tom

I have noticed that some queries can be written to and others cannot be
written to.

What is the rule here? I would like to be able to write to a query that I
currently cannot write to. The form is based on the query.
 
F

fredg

I have noticed that some queries can be written to and others cannot be
written to.

What is the rule here? I would like to be able to write to a query that I
currently cannot write to. The form is based on the query.
Click to expand...


Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated
 
R

Roger Carlson

In the Access Help System (2003), search on "about updating data". Click
this in the Search Results and then click the link called "When can I update
data from a query? (MDB)". This will tell you under which circumstances a
query will be updateable and when it is not.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
A

aaron.kempf

If you moved to SQL Server, then you could utilize 'instead of
triggers' to do this; even when a simple update on a view is not
natively supported.

With an Access Database; you're just kindof subjected to the whims of
the chipmunks that run on the exercise wheel.

-Aaron
 
Top