Unanswered: Cannot edit a SQL table without primary key in Access 2002 adp datesheets? Why?
Tried to edit the SQL 2000 Tables from the Access 2002 ADP, i was able to edit a table with Primary key but wasnt able to edit a table without.
Why should i force my database design to have one, i know that i would be a better design but my design does'nt needs a pKey.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!