How do you create Acces Data Pages for update

[BCV0114]

I am a first time user of access. i am trying to create an Data Access Page which will list all entries in a table and then allow me to add, change and delete them. I have created the page using the wizard but it will not let me add, delete or update. i view all the entries at one time but that is all. the navigation toolbar shows up at the bottom but it is grayed out. any ideas on what i may be doing wrong?


thanks
brian

 

[dionem]

Hi Brian,

I have struggled with the same thing & came to the conclusion that a data access page is for "accessing" the data only - not for updating/editing it.

I hope that I am wrong & someone else can help out.

Dione

 

[BCV0114]

Thanks, my book says it should work so i am assumming i am doing something wrong. hopefully it can be done. thanks again for the info.


brian

 

[shadows]

hi there. thought i give you a point or two from my limited knowledge

when you create a form, there's a function which you can include to update, delete, modify etc if i'm not mistaken. I have done this before. Please check.

 

[Laurentech]

I just created a page in my database I am working on to try it out, and it allows me to edit the data. I used the wizard to make it, and it gives you the option of adding grouping levels, but states that adding grouping levels will create a read-only page. Perhaps that's what you are seeing.

Larry

 

[reclusivemonkey]

You need to make sure the table you want to update has a primary key for a DAP page to be able to update it.