Form will not allow data entry

[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.

 

[Allen Browne]

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.

 

[koper]

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

 

[Allen Browne]

See:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
for a list of possibilities