I have a Access database linked to VB. I am trying to use FIND through ADODC to locate a file , but I keep getting "Cannot update 'Client#'; field not updatable". I think it is because its a AutoNumber data type in Access, but I don't want to change it. Could someone tell me how to get round this problem?
Code below: -
Dim ClientNumber As String
ClientNumber = AdodcCarePlan.Recordset.Fields("Client#")
AdodcClient.Recordset.Find "Client# = 'Client Number'"