Solved

Access Form Not Editable

Posted on 2011-09-28
3
316 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

743 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

14 Experts available now in Live!

Get 1:1 Help Now