Access Forms: Data Entry Problem

[Guest]

I've created a small project reporting DB. The form I use to enter data will
allow data to be entered for a period of time (several days) but at some
point will stop allowing changes to the data. No errors are returned, and I
can scroll through the projects (each project is a record in the main tbl.)
using the record navigation and select the project record (from a list box).
The list boxes, textboxes, and subforms are all displaying the correct
information, but when I enter them and try to update the data the nothing
happens. This is really perplexing as I can create a new form and it will
allow the data entry - I've done this twice already.
I've checked all the form properties (allow edits, deletes, record locking,
etc), the properties for all the fields and the underlying query. All seem
to be in order.
Any ideas?

 

[Allen Browne]

Below is a standard sequence for sorting out a problem database.

If that doesn't fix it, tell us more about this form:
a) The Record Source property of your form: Is it the name or a table? Or it
is a query that uses multiple tables?

b) Is there only ever one copy of the database open at a time? Or are there
multple users at once? If multiple, consider splitting the database:
http://allenbrowne.com/ser-01.html

c) What events of the form are you using? Comment out anything in the form's
Timer event, and be careful not to dirty the form unnecessarily
(particularly in Form_Current or Form_AfterUpdate.)

d) What version of Access? And what Service Pack?
(Choose About on the Help menu.)

Here's the fix-database sequence (in order.)
If split, do this on the back end as well as the front.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html