Form not working after upsizing to SQL

[jezmondo]

I have upsized a database developed by someone else in Access to SQL Server. A form within the database has a Master / Detail structure which works fine when the tables are held locally in Access. When the database is linked to the tables on the SQL Server however, trying to update the Detail part of the form produces the following error: "Cannot add records; Primary key for table 'Detail' not in recordset"

I've had a look at the table design and there's no Primary Key defined. The two fields used to join the detail table to others contain duplicated and the only unique field in the table is used for indexing but not as a primary key or for any joins.

Any ideas why this works in Access but not when linked to the upsized tables on SQL Server???

Also, I've tried upsizing the database and using the 'Create new Access Client / Server application' option in the upsize wizard but this results in the loss of all the predefined forms / reports etc???

 

[SQLSister]

All tables in SQL Server must have a unique field defined or a primary key or they will not allow Access to enter data.

 

[jezmondo]

Thanks SQLSister - the table in question does have a unique index field but I'm still unable to add a record???

 

[SQLSister]

Are you sure that SQL server sees it as a unique index, sometimes those thing don't transfer inthe upsizing process.