Queries won't let me type in them

  • Thread starter Thread starter Isidore
  • Start date Start date
I

Isidore

In my new database, (adapted from data from an old one), I have a few
form built on queries. I cannot type into any of the fields. The
queries also won't let me type or change anything. However, when I go
directly to any of the underlying tables, everything is all right.

Can anyone suggest how I might correct this?

Thanks in advance,
Isidore
 
Queries can be made Non-Updateable in a number of ways. Here are a few:

1) Adding a Distinct Predicate to it
2) Creating a Join where there is no Unique index on the join field in one
of the tables
3) Creating a Join of three tables in a Many-to-One-to-Many relationship
4) Making the query a Crosstab query
5) Making the query a Totals query

There are others as well. You can find a more comprehensive list in Hellp.
Type "Updatable" (without the quotes) into the Index and choose: "When can I
update data from a query?" from the topic list. (This is one of the few
known places where Access 2000 help is easier than 97 <grin>)
 
If you are not even able to click in the cells of the query design grid, and
you are using Windows XP, try turning off the XP themes.

Right-click the desktop, and choose Properties.
On the Themes tab, choose Theme, "Windows Classic".

If that is not the issue, have you set up some kind of security where you do
not have permissions to modify them?
 
Back
Top