access 2003 rocrds not deleted, data is read only
Posted on 2010-09-05
I've read numerous forums none of which work.
(Access 2003 with Jet dB)
I have a form with a subform within it.
The form programatically sets the record source for the subform.
Thi works fine. only the selected records are displayed.
However, when I go to manually delete one of the records I get the message "records not deleted, data is read only' in the status bar.
Ive checked the permission on the DB. In fact if I go to the table directly I can delete it OK.
The table I display has no joins. It also has a single field primary key which is also unique.
Here's my sql
Dim strsql As String
strsql = "SELECT record_id, user, batch_num, product, barcode, description, quantity FROM tbl_Data "
strsql = strsql & "WHERE (User='" & CurrentUserName & "')"
Me.tbl_Current_Batch_subform.Form.RecordSource = strsql
CAn anyone help.
It must be something simple or stupid.