Adding data in a Query

Hello,

I am trying to add data to a query I've run so the changes will be reflected in my table. However, I keep getting this message: "This Recordset is not Updateable". Does anyone have any ideas as to why this is happening? You should be able to add data to a query and have it update to your table, right?

Thanks for the help!!

Post the code and what your are trying to update.

Gazza

Gazza,

Thanks for replying. There really isn't a piece of code involved, per say. The query pulls back 4 four fields from my table. I'm running a query first so I can have just the columns I want from my table in one view. Based on information on two of the fields in the query, I will input data into the other two fields. I then want the data I entered into the query to update to my table. Again, the error I receive is "This Recordset is not Updateable".

Thanks in Advance!

:eek:

Nicole

This may sound daft but is the recordset you created an updatabale i.e.

a Dynaset or Keyset recordset as oppsosed to a Snapshot or Static recordset

:cool: Gazza :confused:

Gazza,

Great point! Well, I guess my "daft" question is: How do I make my recordset updateable? And, how can I tell if my recordset is currently a Dynaset or a Keyset?


Thanks again!

Is this an Access query or VB sql?

Joedoer,

This is an Access query. Any ideas on how to make a recordset updateable?


Thanks!

I ran into this problem once before where someone had messed with their permissions in an access database and she couldnt write to records in a table and it said "not updatable", if your using ADO just specify something other than adLockReadOnly for the LockType

JasonGS,

Thanks for responding. Actually, I am getting this error when trying to add records to a query, not my table. Also, I'm not sure what ADO is, so I'm probably not using it, But thanks for the advice!!