Form will not allow data entry

  • Thread starter Thread starter koper
  • Start date Start date
K

koper

Today my database which has been working fine for 10 years quit working. I
have tabbed controls of which some are subforms. All of the subforms work
fine, but the tab-control pages will not allow any data entry and no error is
given. I checked to make sure that the page properties and field properties
are not locked. I can enter data directly into the backend of this database.
Why would this happen to only tab controls and not subforms. I suspect this
is a problem of the back end as prior front ends (that have not been used
for months) do not allow the changes also.

Any suggestions.
 
Can you modify the data in the linked tables in the front end?

If the form is based on a query, can you modify the data in that query?

Check the Data properties of the form, particularly:
Allow Edits Yes
Allow Additions Yes
Recordset Type Dynaset

If the form is based on a query, and the query has gone read-only without
anything else changing, open the back end and check if all relationships are
present. Look for any new tables, particularly with a name like Compact
Errors.
 
I can modify any of the tables, but I cannot modify any of the data in the
queries. All Data properties are fine. I guess the query is read-only by the
fact that I can't edit date in the query. There are no compact errors, and
all relationships look intact. Any other help? This ocurred recently after
upgrading server and I do not know if this was part of the cause but does not
make sense.

thanks. koper
 
Back
Top