I just added a field (EmployeeID) to an encrypted table in SQL server 2005. Then I linked that table to a MS Access application.
The issue is that when I append records via the linked table, all the other fields are getting populated except the EmployeeID field I just added.
If I do a copy and paste of an entire record, the field doesn't get populated. But if I specifically enter a value in the field, it keeps the values.
What could explain this strange behavior?