Recordset Not Updatable (1 Viewer)

[rustyg]

Hi,

I am having a problem running a macro which calls on 4 queries. Each one relies on data from the last one, they all seem to run properly except one which displays the message "this recordset is not updatable" down the bottom of the screen.

Anyone know what the problem is here and how I can fix it?


Russ

 

[bvan]

Here are 2 very common reasons for "not updatable" recordsets.

1. Missing primary keys: Make sure all of your tables have a primary key. Use an autonum if you must, but you are better of using a unique field or concatenated unique fields.

2. Grouping (Totals) queries: If you are using a grouping query as a subquery, it will not be updatable. Make a temp table out of the grouping query and use the temp table in place of the subquery.

 

[LukeChung-FMS]

Here's a paper I wrote which you may find helpful in these situations:

Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access

Good luck.
Luke

 

[vbaInet]

Here's addendum to what LukeCheng-FMS and bvan have advised:

http://allenbrowne.com/ser-61.html
http://support.microsoft.com/kb/328828

 

[boblarson]

Here's a paper I wrote which you may find helpful in these situations:

Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access

Good luck.
Luke

Hey Luke! Glad to see you here. Long time, no see.