Data Access Page

T

Tom

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.
 
T

Tom

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.
 
D

Douglas J. Steele

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.
 
Top