cannot change field values

  • Thread starter Thread starter R. Kumana
  • Start date Start date
R

R. Kumana

My Access database was working fine for months until
today. Now, it is acting up. The first and major probelm
is, I have a form that will not allow me to change any
values of any fields. I checked all the properties:

Alow Edites = Yes
data Entry = No
Record lockes = No locks

the form record source is a query that reads from a linked
table.

What could it be?
 
The back end database was set to read only? You lost Write privilige on
a network drive? The database has become corrupted?

Pavel
 
My Access database was working fine for months until
today. Now, it is acting up. The first and major probelm
is, I have a form that will not allow me to change any
values of any fields. I checked all the properties:

Alow Edites = Yes
data Entry = No
Record lockes = No locks

the form record source is a query that reads from a linked
table.
Click to expand...

Try opening the Query directly; is it updateable? Where is the linked
table? Have the permissions changed on the database?
 
-----Original Message-----


Try opening the Query directly; is it updateable? Where is the linked
table? Have the permissions changed on the database?
Click to expand...
No, it's not. Strangely enough, only this particulr query,
and any others based on it, have this problem. All other
queries still allow updates.

the linked table is in a backend file that is in the same
folder. Permissions were never changed. All users still
have all permissions.


Does this narrow it down?
 
-----Original Message-----
The back end database was set to read only?
Click to expand...

No. I can modify table data, including the table the query
is based on.

You lost Write privilige on
a network drive?
Click to expand...

I moved the backend file to the same directory and reset
the links. It did not change.


The database has become corrupted?

How do I tell?
 
Well, it took a long time, but I traced the problem. The
query would not update due to a single linked table. When
the table was removed, it worked. The table relationships
in the front end showed a duplicate af the table that was
not present in the backend. The duplicate could not be
removed. The duplication was apparently the result of a
few forms on which I had inadvertently given some of the
controls the same name as the table. Somehow this caused
the duplication.

When I was first starting out with access, I didn't
add "Qry" "frm" and "tbl" to the names of objects I
created. This led to the name conflicts later on.

Rather than search out every instance of those, I renamed
all my tables with "tbl" at the end. I had to go through
all my queries and redo their table references.
Fortunately I was in the practice of basing all my reports
and forms on queries vice tables, so most of them are
still working.

I still don't know how the name conflict caused the
problem, why it only affected the one query, and why it
only started this week.

It just goes to show, "good practices" are called that for
a reason.
 
No, it's not. Strangely enough, only this particulr query,
and any others based on it, have this problem. All other
queries still allow updates.

the linked table is in a backend file that is in the same
folder. Permissions were never changed. All users still
have all permissions.


Does this narrow it down?
Click to expand...

Sure... you know it's the query, not the form!

I suspect that the query might have become corrupted. MAKE A BACKUP of
your database; use Tools... Database Utilities... Compact and Repair
to possibly repair the database (if you haven't already; this should
be routine maintenance). If (as I suspect) that doesn't work, open the
query in SQL view and copy the SQL text out to Notepad or some
external file. DELETE the query; compact the database to expunge its
residue; and create a new query in SQL view by copying and pasting the
saved SQL text.

If that doesn't help, post back... and post the SQL.
 
Back
Top