ADP Newbie Question

[Guest]

Hello. I've just created a new Access ADP project connecting to a SQL Server
database on another server. When I add a new form based on a single table,
using the wizard, it disables the "Add New Record" button in the navigation
buttons ("Delete Record" button too). And for the life of me, I can't find
any properties on the form that can change this behavior. I need to be able
to add new records. What am I missing?

Thanks!
John

 

[Sylvain Lafontaine]

Probably a missing primary key on the table.

 

[Guest]

Yep, you were right! When they moved the data from Access to SQL Server,
they didn't create any of the keys or indexes.

Thanks,
John