Editing Records in MS Access

Question

I am using MS Access (2002-2003 file format) and in the file I have a form. When I click on the form, I get a table with records. I would like to edit those records, and want that edited records are stored in the database. However, the problem is every time I double click on the field I want to edit, I hear annoying sound from Windows, and cannot edit any field.

Has anyone a suggestion, how does record editing function in MS Access, and why can't I edit records? Do I have to enable something?

Thx

UPDATE: I found on google the recommendation, that I should change Recordsettyp from 'Dynaset' to 'Dynaset (inconsistent updates)'. When I did that, I could change records. However, is this allowed to do, and what consequences does this setting have?

Few things could cause the problem. First, check if the Form is allowed for Edits (Under Property Sheet -> Data (Tab) ->Allow Edits (Property)). Next thing to look would be the Recordsource. Sometime the Recordsource might be non-updatabale, check Why is my query read-only? - allenbrowne.com/ser-61.html — PaulFrancis
where do I find both properties? (I am using access in another language) — Adam
I found on google the recommendation, that I should change Recordsettyp from 'Dynaset' to 'Dynaset (Inkonsistente Aktualisierungen)'. When I did that, I could change records. However, is this allowed to do, and what consequences does this setting have? — Adam
I have also read, that it would be the best thing not to use inconsistent updates. However, how can I avoid using it? Is there an alternative? — Adam

StackJavo StackJavo · Accepted Answer · 2016-01-19T11:54:54

Two possibilities of why you cant edit. 1) the form should be editable in the properties. 2) if your form is getting information from a query. The query should be simple. I mean no totals or no bringing many fields from different tables which are one to many. Solution to 2? Instead of getting data from that query. You should append that query into a table. And then get the data from that table and then update the real table.

Real table x > Append info you want to show in form to > table y > show in form > when close form, you update table x with y.

Hope it helps

Editing Records in MS Access

1 Answers