Error 3027, DB writeprotected

  • Thread starter Thread starter BrunoKP
  • Start date Start date
B

BrunoKP

I get error 3027 (writeprotected) in the line ".AddNew" after I have changed
the datasource to my Form from "tblTimeReg" to a query. The query includes
all the fields of "tblTimeReg" and some fields from two other tables which
are joined by PersonID "one to many". I suppose that I get trouble because
the Form no longer owns the table, how can I obtain write access?

Set RecSetTimeReg = dbsCurrent.OpenRecordset("tblTimeReg", dbOpenDynaset)
With RecSetTimeReg
.AddNew
![PersonID] = Me.PersonID.Value
 
Cancelation
I solved the problem by changing the query, sorry I you have used time for
that.

"BrunoKP" skrev:
 
Back
Top