Subform in datasheet view - can't add new records? 1

[embryo]

Hi all-

I recently upsized to SQL Server 2000 and created an Access 2003 ADP using an Access 2003 MDB that worked perfectly.

I've got a subform on a form and have it set to be in datasheet view. Previously, there was a "new record asterisk thingy" located in the very last row of the datasheet, but now that it's been converted, there is not.

I have "Allow Additions" set to "Yes" as before, but no cigar.

When I change "Data Entry" to "Yes", it seems to apply an "evil magic filter" because no records are displayed at all. When I remove filter/sort on it, it then removes the initial filter for the parent form and shows every record from the sub dataset in the subform.. B-(

Regardless whether I'm logged onto the SQL Server as the owner or not, it behaves the same way, so I guess it's not a permissions issue.

Can somebody please shed some light on this form me?

Thanks,
Steve

 

[embryo]

I should have also mentioned that even the right-click Add Record and New Record options are greyed-out-

 

[cjowsey]

Make sure that you have a primary key on all the tables you have created in SQL Server. If you don't, you can't update the tables through an ADP.

If you are trying to update a view formed from multiple tables, it can help to set the primary table.

 

[embryo]

That was the problem!

One of the joined tables had no primary key.
When I upsized last week, none of the linked tables were upsized and i had to drag-n-drop a bunch of tables...some lost definitions, and this one had no primary to begin with.

Thank you very much.

By the way...I've just posted another topic that at the bottom seems similar to this same issue, though not a subform issue..inability to add/delete/edit records..
..but in this case, there is only one table, and it has a primary key...

Steve
---------------------------------------
IF WebApplicationProgrammer = True Then
ElectronicSheepHerder = True
End If