Form not allowing updates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arnold Klapheck - 28 May 2008 17:35 GMT

when I try to update/edit in my form I get the message, "The recordset is not
updateteable"
Using Access 2007, on properties it says my recordsource is the correct
table, allow edits is set to yes, it is not locked.

I based the form off a query that pulls fields from three different tables
and it seems to post up right. I am thinking it is using the query as the
recordset hence it cannot update the table? Any Ideas how to fix this?

Reply to this Message

Ken Snell (MVP) - 28 May 2008 18:54 GMT

A three-table often is a nonupdatable query, so likely that is the problem
with your form. You can test this by opening that query in datasheet mode
and looking to see if the "new record" button (the one with the star on it)
is greyed out -- if it is, the query is nonupdatable.

Post the SQL statement of the query so that we can have more information.

Signature

Ken Snell
<MS ACCESS MVP>

> when I try to update/edit in my form I get the message, "The recordset is
> not
[quoted text clipped - 5 lines]
> and it seems to post up right. I am thinking it is using the query as the
> recordset hence it cannot update the table? Any Ideas how to fix this?

Reply to this Message

Linq Adams - 28 May 2008 19:28 GMT

Here's Allen Browne's article on why some queries are read-only:

http://allenbrowne.com/ser-61.html

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

Golfinray - 28 May 2008 19:24 GMT

Check and make sure your table and query are editable (they should have an
arrow and asterisk at the bottom.) If they don't you will probably need to
rebuild one or both. If your table and query are not editable, neither will
your forms be editable. Some types of queries, like union or crosstab are
never editable. If you have one of those you could try to take that query,
turn it into a select query and then try maketable.

> when I try to update/edit in my form I get the message, "The recordset is not
> updateteable"
[quoted text clipped - 4 lines]
> and it seems to post up right. I am thinking it is using the query as the
> recordset hence it cannot update the table? Any Ideas how to fix this?

Reply to this Message

Arnold Klapheck - 28 May 2008 21:19 GMT

It seems I made my main table uneditable, I don't remember when I did that
and I cant figure out how to make it editable, any suggestions?

> Check and make sure your table and query are editable (they should have an
> arrow and asterisk at the bottom.) If they don't you will probably need to
[quoted text clipped - 11 lines]
> > and it seems to post up right. I am thinking it is using the query as the
> > recordset hence it cannot update the table? Any Ideas how to fix this?

Reply to this Message

Golfinray - 28 May 2008 21:26 GMT

Allen Browne has some good tips on tables that are not editable. Try
www.allenbrowne.com and check his Access tips. One thing to try first though,
is just to recreate the table, if possible. Also check help because I think
there is a good help article on what causes tables to be uneditable.

> It seems I made my main table uneditable, I don't remember when I did that
> and I cant figure out how to make it editable, any suggestions?
[quoted text clipped - 14 lines]
> > > and it seems to post up right. I am thinking it is using the query as the
> > > recordset hence it cannot update the table? Any Ideas how to fix this?

Reply to this Message