CODEWITHSUNDEEP
vbadatabasems-access
datagirl
datagirl

Reputation: 1

How to allow edits to Access database via a Form in the front end of Access Database?

My access data base form won't let me update data (back end is Access database as well). It shows me a "This Recordset is not updateable" error when I try. Currently the form is pulling records from the back end. Currently the form won't change the original value it pulls from the database; but I want users to be able to update those values.

Option Compare Database

Private Sub CellID_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub Command23_Click()
On Error GoTo Err_Command23_Click


Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFind

Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub
Private Sub Command24_Click()
On Error GoTo Err_Command24_Click


DoCmd.RunCommand acCmdSaveRecord

Exit_Command24_Click:
Exit Sub

Err_Command24_Click:
MsgBox Err.Description
Resume Exit_Command24_Click

End Sub
Private Sub Command25_Click()
On Error GoTo Err_Command25_Click


DoCmd.GoToRecord , , acNext

Exit_Command25_Click:
Exit Sub

Err_Command25_Click:
MsgBox Err.Description
Resume Exit_Command25_Click

End Sub
Private Sub Command26_Click()
On Error GoTo Err_Command26_Click


DoCmd.GoToRecord , , acPrevious

Exit_Command26_Click:
Exit Sub

Err_Command26_Click:
MsgBox Err.Description
Resume Exit_Command26_Click

End Sub
 Private Sub Command27_Click()
On Error GoTo Err_Command27_Click


If Me.Dirty Then Me.Dirty = False
DoCmd.Quit

Exit_Command27_Click:
Exit Sub

Err_Command27_Click:
MsgBox Err.Description
Resume Exit_Command27_Click

End Sub

Private Sub Ctl50th_DC_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub Dc1_BeforeUpdate(Cancel As Integer)

End Sub

More specifically, looking to update DC1 and 50th_DC

Upvotes: 0

Views: 458

Answers (1)

Albert D. Kallal
Albert D. Kallal

Reputation: 49059

Well, in place of trying to use a bunch of code and forms, FIRST check if you can open a linked table in your front end. If that does not work, then no use trying a complex form or code. So, the linked tables should work. Can you click on a linked table, open it, and see data? If that works, then try while looking/using that open table to edit a record. If you can't from the UI edit records, then code or forms also will not work.

So, test/check by simple opening a linked table.

If you can't edit data, but can see data in a table?

Then this suggests the back end is in a folder in which you don't have create file rights, and delete file rights.

You as a general rule need BOTH create and delete rights in that shared folder in which (where) your back end accdb file resides. If you don't have create file rights, and delete file rights, then in MOST cases, Access will open those tables as READ only - and you can't update them.

So, check the folder permissions where the back end resides.

Upvotes: 2

Related Questions