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...
Top Bottom