Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    30

    Unanswered: Data Access Page problem

    Ive tried several times creating a data access page for a table containing data. However, the data navigation buttons are greyed out and only allows me to scan through records. This is significant in my case as I need to be able to delete and add records.

    This is particularly odd as I tried the same thing the other day on another DB i made in access 2002 and it worked fine. I subsequently tried this again when trying to root out the problem and im now getting the same thing on the other DB that previously the data access page allowed me to add records.

    I thought it might have something to do with read only or something but ive made a form and it allows me to add and delete through that fine.

    help please!!!???

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Try this for starters:

    ACC2000: Can't Add, Edit, or Delete Records on Data Access Page

    <Are you including the primary key of the table?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    May 2009
    Posts
    30
    Quote Originally Posted by garethdart
    Try this for starters:

    ACC2000: Can't Add, Edit, or Delete Records on Data Access Page

    <Are you including the primary key of the table?

    Excellent man, cheers. Left out the primary.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •