• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • 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?
0
darrennelson
Asked:
darrennelson
1 Solution
 
burrcmCommented:
May be corrupt, not uncommon with Access. Try creating a new blank database and importing all the items from the problematic database.

Chris B
0
 
puppydogbuddyCommented:
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
0
 
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.
0
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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