please help 3027 error cant update, database or object is read-only

[nicklewis]

this was working but now has decided to not work today.
any ideas?
this is the code and it has stopped where the * is

If txtday = "Monday " Then
txtanswer = txtminus3day
Else
txtanswer = txtminusoneday
End If

tblDate.MoveFirst
Do While Not tblDate.EOF
If tblDate![Date] = txtanswer Then
Exit Sub
Exit Do
End If
tblDate.MoveNext
Loop



*tblDate.AddNew
tblDate![Date] = txtanswer
tblDate.Update

 

[PHV]

Any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nicklewis]

oh yeah sorry

it says "can't update, database or object is read only"

the only thing that we have been doing latley is upsizing the db to sql but havent had a chance to touch the table called date yet anyway

 

[PHV]

How is the tblDate opened ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nicklewis]

tbl date is the recordset in which opens the table Date

what this process is doing is finding todays date minusing one day from it then adding it automatically if not already entered to the date table

 

[PHV]

My question was: please post the code showing us how you open the tblDate recordset.
Another question: in the table window can you modify/add/delte records from the date table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nicklewis]

no i cannot add to the table strange how do i get around this

sorry the start of the cod is

Dim db As Database
Dim tblDate As Recordset

Set db = DBEngine.Workspaces(0).Databases(0)
Set tblDate = db.OpenRecordset("Date", dbOpenDynaset)

 

[PHV]

Does have the date table a PrimaryKey recognized by Access ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nicklewis]

yes it has two fileds very simple table

DateId autonumber primary key
Date

 

[PHV]

So, seems you have to check the permissions for this table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886