Solved

Access Form Not Editable

Posted on 2011-09-28
3
318 Views
Last Modified: 2012-08-13
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
Comment
Question by:darrennelson
3 Comments
 
LVL 28

Accepted Solution

by:
burrcm earned 250 total points
ID: 36814079
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 36814269
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
 

Author Comment

by:darrennelson
ID: 36818247
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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now