Error 3027, DB writeprotected

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
 
B

BrunoKP

Cancelation
I solved the problem by changing the query, sorry I you have used time for
that.

"BrunoKP" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Error 3027 - Db or object is Read Only 4
Table Lookup Field - options relative to record 1
Error 3027 9
QBF & Query Malfunction 0
Cannot update DAO Recordset 6
How to refresh a single record in a datasheet subform? 1
Add Fields from Record 1

Top