Update ability stopped

  • Thread starter Thread starter Jim Moore
  • Start date Start date
J

Jim Moore

I have an application in Access 2002 that has lost the ability for a form to
update a table. The form is based on a Query of one table and a Subform for
a second table. One criteria of the Query if for the value of a field named
"ActionCompleted" to be "No". In the application, the user completes the
information in the Subform and then clicks the "ActionCompleted" CheckBox.
When I developed the application a year ago, clicking on the CheckBox would
update the table underlying the query. I have compared an archived copy of
the application and can find no differences. I have exported the archived
form that works to the current application but it still does not work. The
data properties on the CheckBox are Enabled - Yes, Locked - No and Triple
State - No.

I suspect that the data table is somehow corrupted, but do not know what to
look for or how to correct. I have compacted the database. I am able to
mannualy toggle the value of ActionCompleted when editing the table.

Any leads you may give me?

Jim Moore
 
Jim said:
I have an application in Access 2002 that has lost the ability for a form to
update a table. The form is based on a Query of one table and a Subform for
a second table. One criteria of the Query if for the value of a field named
"ActionCompleted" to be "No". In the application, the user completes the
information in the Subform and then clicks the "ActionCompleted" CheckBox.
When I developed the application a year ago, clicking on the CheckBox would
update the table underlying the query. I have compared an archived copy of
the application and can find no differences. I have exported the archived
form that works to the current application but it still does not work. The
data properties on the CheckBox are Enabled - Yes, Locked - No and Triple
State - No.

I suspect that the data table is somehow corrupted, but do not know what to
look for or how to correct. I have compacted the database. I am able to
mannualy toggle the value of ActionCompleted when editing the table.

Any leads you may give me?

Jim Moore
Click to expand...
Check to see if you have changed the query in some way which now makes it
not updatable.

Ron
 
No, no changes were made to the query. I deleted the 4 key tables in the
database and exported those from the archived database back to this database
and reesablished the relationships. The application works now, but a year's
data is in limbo.
Jim Moore
 
The application works now, but a year's
data is in limbo.
Click to expand...

If you deleted the tables, and didn't keep a backup of the database
prior to doing so, the year's data is gone for good! :-{(

If you did keep a backup, even if the tables are corrupt, you may be
able to salvage most of the data by linking to it and importing. See
the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Yes, I did backup the database before deleting. Thanks for the link; I'll
try to recover the data.
Jim Moore
 
Back
Top