LEFT JOIN produces 3027 Error: Cannot update. Database is read only

[ccsenn]

I would appreciate any advise on resolving a 3027 - Database is read only error.

Thanks in advance!



Charlie

Dim Faculty As DAO.Database
Dim AADSSolicitationsDynaset As DAO.Recordset

SelectPhrase = "SELECT AADSSolicitations.SolicitationNumber, AADSSolicitations.DatelastProcessed, " & _
               "AADSMultiYearAnnouncements.[Obsolete-LT120Days] " & _
               "FROM AADSSolicitations LEFT JOIN AADSMultiYearAnnouncements " & _
               "ON AADSSolicitations.SolicitationNumber = AADSMultiYearAnnouncements.SolicitationNumber " & _
               "ORDER BY AADSSolicitations.SolicitationNumber"

Set AADSSolicitationsDynaset = Faculty.OpenRecordset(SelectPhrase, dbOpenDynaset)

AADSSolicitationsDynaset.AddNew  '"3027 Cannot update. Database is read only" is generated'
AADSSolicitationsDynaset![SolicitationNumber] = 537
AADSSolicitationsDynaset![DateLastProcessed] = Date
AADSSolicitationsDynaset.Update

[June7]

Must be an issue with the table relationship and the join type.
Review: http://allenbrowne.com/ser-61.html

Or maybe just need to end the SQL with a semicolon.

[ccsenn]

Most Excellent! Many thanks for your list of possible causes. I had failed to establish the correct relationship between the tables. Once I did that and modified the SQL phrase appropriately, I was good to go!

Did I mention I also appreciated the same day response!

Charlie