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'