Recordset is not updateable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K - 18 Jan 2005 15:11 GMT

I have a form that does auto-complete without code. But I am getting an
error that says Recordset is not updateable. Do you have a solution to fix
this problem. The form is filled out but from the combo box you cannot
select from it and you cannot type on that section of the form.

Thanks,
K

Reply to this Message

John Vinson - 18 Jan 2005 22:12 GMT

>I have a form that does auto-complete without code. But I am getting an
>error that says Recordset is not updateable. Do you have a solution to fix
[quoted text clipped - 3 lines]
>Thanks,
>K

The Form's Recordsource property is presumably the name of a Query;
you are getting this message because that query is not updateable. Try
opening the Form in design view; view its Properties; on the Data tab
click the ... icon by the Recordsource property to open the query in
design view. If you look at it in datasheet view, do you see a *> "new
record" line at the bottom? Can you change data in the datasheet?

If not, check the following issues:

- Is it a Totals query (is the Greek Sigma icon selected, and is there
a Totals line in the grid)? If so, it is not and cannot be made
updateable.
- If it's a multitable query, do you have a unique Index such as a
Primary Key on the "one" side table joining field?
- Or, is it a query with four or more tables? Such queries are rarely
updateable.

If you can't figure out why it's not updateable, open the query in SQL
view and post it here.

John W. Vinson[MVP]

Reply to this Message

K - 19 Jan 2005 16:15 GMT

I still can't figure out why it's not updateable. Here is my query in SQL
View id you can help me I really appreciate it.

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[Site/NameID] =
tblCustomers.[Site/NameID]
ORDER BY tblCustomers.[Site/Name];

Thanks,

K

> I have a form that does auto-complete without code. But I am getting an
> error that says Recordset is not updateable. Do you have a solution to fix
[quoted text clipped - 3 lines]
> Thanks,
> K

Reply to this Message

John Vinson - 19 Jan 2005 20:03 GMT

>I still can't figure out why it's not updateable. Here is my query in SQL
>View id you can help me I really appreciate it.
[quoted text clipped - 5 lines]
>tblCustomers.[Site/NameID]
>ORDER BY tblCustomers.[Site/Name];

Is [Site/NameID] the Primary key of tblCustomers? Or does it otherwise
have a uniuqe Index?

John W. Vinson[MVP]

Reply to this Message

K - 21 Jan 2005 13:57 GMT

The SiteNum is my primary key. Is that how it should be. Do you know why I
having the Recordset is not updateable error. If you can help I would really
appreciate it.

Thanks,

K

> >I still can't figure out why it's not updateable. Here is my query in SQL
> >View id you can help me I really appreciate it.
[quoted text clipped - 10 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 21 Jan 2005 17:55 GMT

>The SiteNum is my primary key. Is that how it should be. Do you know why I
>having the Recordset is not updateable error. If you can help I would really
>appreciate it.

If SiteNum is the primary key, you should be joining on that field
rather than on the Site/NameID! Or am I missing something?

Try

SELECT tblCustomers.SiteNum, tblCustomers.[Site/NameID],
tblCustomers.[Site/Name], tblName.Address,
tblName.[Building/Suite],tblName.City, tblName.State, tblName.Zip
FROM tblName INNER JOIN tblCustomers ON tblName.[SiteNum] =
tblCustomers.[SiteNum]
ORDER BY tblCustomers.[Site/Name];

Or if tblName does not have a SiteNum field, you will need a unique
Index on Site/NameID. In any case, it's the field in the INNER JOIN
clause which must have a unique Index (such as a primary key) in the
"one" side table, and a nonunique Index (automatically generated when
you define the relationship) in the many side table.

John W. Vinson[MVP]

Reply to this Message