vb6-ms access returns "OPERATION MUST USE AN UPDATEABLE QUERY" errror
Posted on 2008-06-24
Dim ConStr As String
Set Con = New ADODB.Connection
ConStr = "Provider=Microsoft.jet.OLEDB.4.0; " + " Data source=\\dbsrv\HR\db\db1.mdb;"
Set RsEmp = New ADODB.Recordset
RsEmp.LockType = adLockOptimistic
RsEmp.CursorLocation = adUseClient
RsEmp.CursorType = adOpenKeyset
RsEmp.Open "select * from tb1", Con
the database is stored in a shared directory HR from the computer DBSRV! the update query only works when run locally, but produces an error message "operation must use an updateable query" if run from anyother computer in workgroup.
both administrators and users groups were assigned full control access to the HR directory however i am still getting the same error message! so can anybody help fix it?