SQL Server 2008
I have just finished linking all my Access 2007 front-ends to SQL Server 2008 databases. I used DNS-less connections and the SQL Server driver. Everything seems fine except in several front-ends I have a forms with a datasheet subforms ... and they are not linkling to the parent!?
The table for the parent form has a unique primary key "ORDERID" (int, Identity = yes, no nulls, clustered index) and the subform query has the same field ORDERID (int, Identity = no, nulls allowed, non-clustered index). On the subform properties I have the Master/Child fields set to ORDERID.
If the record on the parent that is displayed already has records that match in both tables, then the subform is accessable, but if I am entering a new record, I can only enter data into the parent form and the subform remains disabled.
Can anyone tell me why? With an Access backend, it works fine, but not with SQL Server backend.
Very important I find a solution ASAP! ... help!