Are queries read-only....?

[armin]

I created a select query which i can edit in the datasheet view, but not from the data access page that is based on this query. It seems to be read-only.

Any suggestions?

 

[Autoeng]

You have to have a save button on the DAP for the changes to stay.

 

[armin]

No, it doesn't let me enter any values into those fields.

 

[Autoeng]

From the big book of knowledge "Access Developer's Handbook"

Rules for entering or editing data on a DAP:

The page can only contain data from a single source (one table or query)

You must use simple controls, like textboxes, comboboxes and so on. You cannot use the bound pivottable control.

You can only display a single row at a time.

Perhaps you have the third situation?

 

[armin]

I really tried what you said but still no results. Maybe I'm doing something wrong here. I created a simple database with only two tables and one query based on those tables. I wanted to upload it to this board but the file is too large. If you'd like to look at it you can download it from this address: http://24.24.99.239:8080/db1.zip

Try to create one simple DAP using the query and you'll see that the fields can not be modified. Or maybe you know how to solve this.

Thanks for your help.

 

[Autoeng]

Oh yeah. To be editable the PK has to be on the page even if it's hidden. Try that.

 

[armin]

What is PK?

 

[Autoeng]

Primary Key.

 

[armin]

Primary Key from the table? As far as I know there are no primary keys in queries. Right?
If you already made changes to it, you can email it to me ilemajic@memphis.edu

 

[Autoeng]

I couldn't get it.

Create an autonumber field in your table(s) and make it your primary key(s). OR just make one of the existing fields in your tables the PK. Put this in the query. Drop it on the DAP and make it hidden. Should work then. I'll work you up a sample if it doesn't,

 

[armin]

Yeah, it would be great if you could make a sample DB so I can see what you did.

Thanks