Hi guys I am having a problem when I enter data. I'm on Access 2007 its an ADP with sQL Server 05. Can anyone help pls
This error can occur if the data you are attempting to save is saving to a Microsoft SQL Server 7.0 or earlier database and the RecordSource for the subform is using an SQL select statement with fields pulled directly from the source table, and the table is using an Identity field set as its primary key.
To avoid this problem set the RecordSource property of the subform to a table or a query.
Upgrade to a newer version of Microsoft SQL Server.