• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Access Form Not Editable

I have a bunch of forms we use to front end an MS SQL db.  I have the mdb file and can see the form I need to add some fields to, but I can't open the form in edit mode.  I'm using Access 03 and it looks like the db was created in Access 2k (when i do shift+open, the file name is appended with (Access 2000 file format)).

Under Objects->Forms, the only option not grayed out is Open.  If I check Objects->Tables | Objects->Queries | Objects->Macros, Open, Design, and New are available.  All other objects only have the Open option available.

Any idea how I can edit the form?
1 Solution
May be corrupt, not uncommon with Access. Try creating a new blank database and importing all the items from the problematic database.

Chris B
If the form's underlying recordsource is a query, run the query by itself and try to edit it.  If the query is not editable, then your problem is with the query and not the form.  See the link below for reasons why a query might not be updateable and what you can do about it.
                see http://allenbrowne.com/ser-61.html
darrennelsonAuthor Commented:
thanks for the responses.

the query IS editable.  I came across a similar post that lead me in that direction.

I've actaully started on Burr's reco, thanks guys.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now