Trouble updating table from a select query

[George]

I have just loaded Access 2007 and am having trouble creating a new database
where I update my table from a query. I have done this numerous times in
years past but am totally frustrated tryng to do the same thing today. When
trying to update a record in the query form view. I keep getting the warning
"recordset is not updatable". I have searched high and low for something to
allow table updates via the query and nothing works. I am hoping for some
advice to get me off dead center with this. I don't believe it is a
permissions issue because I am logged on with admin rights. Thank you.

[Rick Brandt]

Re: Trouble updating table from a select query

George wrote:

I have just loaded Access 2007 and am having trouble creating a new
database where I update my table from a query. I have done this
numerous times in years past but am totally frustrated tryng to do
the same thing today. When trying to update a record in the query
form view. I keep getting the warning "recordset is not updatable". I have
searched high and low for something to allow table updates via
the query and nothing works. I am hoping for some advice to get me
off dead center with this. I don't believe it is a permissions issue
because I am logged on with admin rights. Thank you.

In all versions of Access most queries do not allow edits. You have built
one that is such a case. Simple SELECT queries against ONE table are
usually editable, but even in that case you can use certain features that
will render the recordset non-editable.

Post the SQL of your query and perhaps someone can point out the problem.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com