Access Query not allowing new entries

S

Shawna

I have a form that was created to a query. I have been using it for about 9
months. Today it stopped allowing new entries. After looking over the form
and table that that the query is built from I have determined the query is
what is causing the problem. If I open the query the "add new record" button
is greyed out. There are no security restrictions on this query. Any
suggestions to resolve this problem?
 
F

fredg

I have a form that was created to a query. I have been using it for about 9
months. Today it stopped allowing new entries. After looking over the form
and table that that the query is built from I have determined the query is
what is causing the problem. If I open the query the "add new record" button
is greyed out. There are no security restrictions on this query. Any
suggestions to resolve this problem?
Click to expand...

You say that it was working until today? Are you sure?
Did someone change the query to make it not updateable?
Perhaps someone changed the query RecordsetType property to Snapshot?

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

Also read Microsoft KnowledgeBase article:
328828 'INFO: Troubleshooting Errors That May Occur When You Update
Data in Queries and in Forms
 
S

Shawna

Yes it was working until today. I have checked the record set type and it is
set at dynaset. I am totally baffled and have recreated the query so that
work can continue but I am clueless as to what caused the original problem.
 
V

Van T. Dinh

Do you use split system with Front-End and Back-End?

If you do, has the design of the Table(s) in the Back-End been changed
without you knowing about the changes?

Try using the Linked Table Manger to relink the Tables to pick up the
changes.

Also try re-creating the Query from scratch.
 
S

Shawna

No updates have been made and it is connected to an access table from the
same database. I created it again from scratch and it works fine. Just drives
me crazy not knowing.
 
V

Van T. Dinh

The must be some corruptions in the old Query or some invisible characters
in the SQL String of the Query. This happened to me a few times. Luckily,
these were really simple Queries so I knew I was correct so I just created
new ones. That's why I suggested to create a new one.
 
Top