We have an Access DB that we recently uploaded the tables to SQL Server and we are still using the ACCESS frontend so we are linked to the tables. I am trying to figure out why the ID field is not populating when a new record is created?
the ID field is the Key field. In access we still show it to be Field Size: Replication ID and Required.
what am I missing?