Adding data in a Query

[NICOLE2000]

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!!

[Gary.Lowe]

Post the code and what your are trying to update.

Gazza

[NICOLE2000]

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!

[Gary.Lowe]

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

Gazza

[NICOLE2000]

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!

[joedoer]

Is this an Access query or VB sql?

[NICOLE2000]

Joedoer,

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


Thanks!

[JasonGS]

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

[NICOLE2000]

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!!