Record Set Not Updateable

Hello,

I am using Access 2000 and I have run a simple Select Query. When I try to add data to the query, I get this message "This Recordset is not Updateable". Can anyone help with this error? How can I add data to the query?

How have you opened the recordset. ado? jet?

BG,

Thanks for replying. I'm sorry, but I'm not quite sure how that relates to what I've done. The way I "open the recordset" is to double-click on the query to open it. Is there another way to "open the recordset"? I know that ado and jet are the database engines, but that's about it...

Thanks again in advance!

sorry, thought you were trying to open it from vb

Nicole

If your qry joins multiple tables,
you're not allowed to update the records
it returns.

Can you give more info on what it is you're trying to accomplish?

Joedoer,

Thanks for your reply. This is a single table query. The table the query is based on contains a large number of columns. I want to be able to see just 4 columns from the table at one time. I then want to be able to make changes to just those four columns and have the changes update to the table. Do you have any ideas as to why I keep getting the "This Recordset is not Updateable" error message?

Couple of questions.

Is the table in your Access.mdb or is it a linked table?
Can you open the table itself and change a record?

Joedoer,

The table is in my Access.mdb file and is not linked. Yes, I am able to open the table itself and make changes to it.

Thanks!

nicole2000

please check your query type (right_click on table)
select update query.