Form won't open in Data Entry mode

JoySloan
JoySloan used Ask the Experts™
on
I have an access form with Data Entry set to yes.  I've been using the database for over a year with no issues and now it's not letting me open just this one form.  The database has a front and back end, and when this began malfunctioning yesterday, I assumed it was a problem with my local front end, but now another user is telling me that he's having the same problem.  The form opens in edit mode with no problem at all.  Please help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Tony HungateClient Success Manager | CISSP

Commented:
Can you upload a copy of your front end.  You can delete anything not associated with the form in question.

Also, what version of Access are we talking about, how many users, how many users may being simultaneously using the database and lastly do you know what kind of record locking is being used?

TLH
Most Valuable Expert 2012
Top Expert 2014
Commented:
Do all users have their own copy of the FrontEnd, installed on their machine?

Before trying these steps, make a backup copy first.

I'd first try a Compact and Repair. Click the Office button - Manage - Compact.

If that doesn't work, try to Decompile first. Build a shortcut with this as the target:

"full path to msaccess.exe" "full path to your database" /decompile

After decompiling, try to Compact again.

If that doesn't work, try moving everything to a new, blank database. Make sure to move over your references and any custom properties, if applicible.

If that doesn't work, try moving everything EXCEPT the trouble form over, and then recreating that form (either from a recent backup or from scratch).

If those don't work, then you're down to the "call the recovery service" step. If you get to that point, please let me know as I have a tool I'd like to try out.

Author

Commented:
I moved everything to a new database and that fixed things.  Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial