 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008Error 3027, DB writeprotected
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: > 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 [quoted text clipped - 6 lines] > .AddNew > ![PersonID] = Me.PersonID.Value |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.