Access 2007 subform not linking to parent with SQL Server Backend
Access 2007
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!
Max
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!
Max
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I feel your pain :)
Here's a very good writeup on some of "best practices" when moving to SQL Server from Access:
http://www.jstreettech.com/files/Best-of-Both-Worlds.zip
Also review some of the stuff from FMS:
http://www.fmsinc.com/tpapers/index.html#SQLPapers
Here's a very good writeup on some of "best practices" when moving to SQL Server from Access:
http://www.jstreettech.com/files/Best-of-Both-Worlds.zip
Also review some of the stuff from FMS:
http://www.fmsinc.com/tpapers/index.html#SQLPapers
ASKER
Thanks LSM!
ASKER
Max