subform update problem

Derek_05 · February 1st, 2006, 11:54 AM

Hi,

I am having problems with updating my database from a subform derived from a Query. It worked fine before and previous versions work fine also. But all of a sudden editing just suddenly isnt allowed. I made sure in the properties on the form/subform that 'Data Entry' = Yes, 'Locked' = No, 'Enabled' = Yes
But its still not allowing data to be edited. (Data can be edited in main table when opened).

Any help, suggestions or advice would mostly be appreciated, Thank you for your time.

Derek

CMensah · February 1st, 2006, 03:38 PM

This has to be a problem with MS Access. I am also having the same problem; I opened a subform that I was able to edit last week but all of a sudden it wouldn't allow me to enter any information since yesterday. I have searched everywhere with no help. Let's hope someone out there will be able to help us.

Good luck!

echovue · February 1st, 2006, 04:04 PM

If the data is not sensitive and either of you would want to send me an email with the database attached in zip file, I would be happy to see if I could figure anything out.

My address is mike-at-echovue-dot-com

Mike

Mike
EchoVue.com

CMensah · February 1st, 2006, 04:16 PM

Thanks Mike. I will email you the database.

Loralee · February 1st, 2006, 10:55 PM

Derek and CMensah,

I've had the SAME problem with one database in particular, Have lost about 12 forms over the past 2 months. When a subform dies, it's query works, the tables are fine, Data Entry and Enabled = True, Locked = no, etc., etc.....

Have given up on trying to figure out WHY it has been doing it, but I now I make a copy for archive both BEFORE and AFTER I make changes. When one of the subforms (or forms) goes, I just import a working copy from the last working archive copy and dump the copy of the form that is not working.

There's been other issues going on with my VBA/Access and I assumed this horrid "feature" was part of them(but if other people are having the SAME problem perhaps not)Our Tech is supposed to rebuild and reinstall my system. I'm using A2k- what about you both?

Loralee

Derek_05 · February 2nd, 2006, 05:16 AM

Hi all
Thanks for taking time to reply. Im very sorry to hear that you all have the same problem without any solutions to it.

I have however found the cause of my problem. The Query!
Data was editable until I added and extra field to the subform, hence Query. And after adding this table, the data is no longer editable in the subform or Query itself in Datasheet view. When that table is removed, everything is fine.

Does anyone know why this is?

That table (Requests) exists with a one-many relation with the Users table.

Thank you for your time and Help

Del

Derek_05 · February 2nd, 2006, 05:18 AM

Sorry Loralee,

I am using Access '03, but the .mdb is in 2000 format.

Del

Derek_05 · February 2nd, 2006, 08:47 AM

Hi again...

After doing some reading on SQL/Query updates I have got my forms/subforms to allow update now based on the Query. The cause of my problem was beacuse the SQL design had more than 3 tables that had a one-to-many relationship. The solution is to change the 'recordset type' property on the form.
from 'Dynaset' > 'Dynaset (Inconsistent Updates)'

Im not sure what implications this will have as the word 'Inconsistent' doesnt sound too good for the DB. But anyway, I went ahead and data editing works fine now.

Hope this helps.

Del

Loralee · February 3rd, 2006, 01:22 AM

Well congratulations on figuring it out. Wish mine was the same. :(
Loralee