Record Set Not Updateable

[NICOLE2000]

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?

[NICOLE2000]

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

[joedoer]

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?

[NICOLE2000]

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?

[joedoer]

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?

[NICOLE2000]

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!

[AldrinW]

nicole2000

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