Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53

    Unanswered: new & delete nav buttons gray

    i've created a dap that connects to a sql server database. It was working at one point but I've been moving the data around from server to server and finally ran into problems using the dap. The dap is used to hold information about different agents that my company writes business for.

    For reasons unknown, the dap can view the records in the database, but cannot modify the records or create new records. The new & delete buttons in the navbar are gray. All the textboxes have readonly set to false.

    I can use query analyzer to insert and delete records using the same user//pass as the dap. Anyone know why I can't modify this database?

    I've recently tried exporting the database to an access file, deleting the sql database, recreate the sql db, and import from the access file.
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

  2. #2
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    the primary key constraint was lost. after re-adding the constraint the dap works properly.
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

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