Data Access Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After using the Wizard to set up a Data Access Page I can't add records. I
have went to the global properties page and made sure that the AllowEditions
and AllowDeletions were set to true. Its not going through a query and I can
add records to the table from Access but not through the DAP.
 
I know I'm going crazy, I'm answering my own question.
I find that you need to have a primary index on the table you are using for
the data access page.
 
That should also have been the case if you were using an Access front-end
(i.e. an MDB) to go against the SQL Server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOw do I prohibit edits/deletes on a DAP 11
Using Data Access Pages to edit data 1
Can't edit data on a Data Access Page 5
Data Access Page Mapped to Database (2003) 4
Data Access Page Mapped to Database (2003) 1
data access page synchronize, update or what? 2
Data entry doesn't work in Data access pages 2
DAP questions (Data Access Pages) 3

Back
Top