Search results

  1. R

    Cannot update. Database or object is read-only. (Error 3027)

    [CODE]/Dim db As DAO.Database Dim rec1 As DAO.Recordset Dim recFiltered1 As DAO.Recordset Set db = CurrentDb Set rec1 = db.OpenRecordset("SELECT [Product Suppliers Name].[Product ID], [Product Suppliers Name].[Supplier] FROM [Product Suppliers Name];", dbOpenDynaset, dbSeeChanges)...
  2. R

    Can insert records in subform but cannot delete records in subform

    I have a subform linked to one mainform The row source of the subform is base on a table. The row source of the mainform is base on a query(should be read only query) because sum(), group by clause, join are used in the query. The common identifier between the table and the query is an ID...
Back
Top Bottom