CAN'T EDIT THE DATA IN ACCESS FORMS

  • Thread starter Thread starter Mondou
  • Start date Start date
M

Mondou

New user in ACCESS.

I am trying to build a catalog database with ACCESS. Problem is,
everytime that I create a form, I cannot edit the database.

I have seen many examples where you can edit the databes and in each
case, the form seems to have an "Allow Edits" field in its Properties
box.

I have tried over and over again to create the simplest sample Tables
and create forms with them but I always end up with the same problem, I
can't find the "Allow Edits" field in my Properties box.

There's obviously something that I have skipped or that I am not doing
right.

Can anyone tell me what ?
 
To find the Allow Edits property ...

Open the form in design view and from the Edit menu choose Select Form to
make sure that the form itself and not one of its controls or sections is
selected. If the Properties window is not already visible, from the View
menu choose Properties. In the Properties window, select the Data tab.

Note, however, that Allow Edits is on by default, so this is probably not
the reason you are unable to edit your data. What happens when you try? If
there an error message? What is the Record Source of your form? (You'll find
it on the same place as the Allow Edits property). Is your data stored in
local Access tables or linked tables from some other data source? If the
latter, what is the other data source?
 
Thanks for your response Brendan.

After playing around with the forms a little, I've noticed that I
wasn't able to edit data only on forms created from Queries.

I went a little further by taking a look at the queries and then the
relationships.

I think that my problem was that I created relationships with fields
that contained similar values (STYLE #) instead of using the Primary
key ( The ID that Access creates ).

I deleted the ID fields and used the STYLE # field of each table as the
primary keys (the ones that I used in the relationships), and BINGO,
everything works fine.

Looks like I've got a lot of learning to go.

Thanks again
 
Back
Top