Edit Query

  • Thread starter Thread starter smh
  • Start date Start date
S

smh

I am running access 2000 (9.0.6926 sp-3) on win2kpro sp-4 machine.
I have several queries on a table in the database. Occasionally when I run
the query to update I can edit the data in the query and it is reflected in
the table in the database the query is built on, at other times, I try to
edit the data in the query, and it won't let me I need to go to the database
table in order to edit. Is there a switch or something or what might be the
problem.

Frustration here.

Thanks for any and all help.

SMH
 
SMH,

There are certain factors which decide whether a query is
"updateable". There is a topic in help about this. For example, if
the query includes a domain function (Sum, Count, etc), or the type of
joins between tables in the query. If you need more specific help,
post back with details of the queries that do not allow editing.

By the way, as a matter of principle, it is generally regarded that
queries and tables should not normally be directly accessed for data
entry/manipulation... that is what forms are for.

- Steve Schapel, Microsoft Access MVP
 
Back
Top