recordset not updatable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to edit data into a current form. I have seen this problem on
several threads, but they usually involve forms using queries as the
recordsource. I am simply trying to use a form to hold and edit data in a
table. Edits Deletions and Additions are all set to "Yes". I have seen an
idication that the problem may lie with the primary key.
 
Here is the SQL for the query:

SELECT DISTINCTROW tblDaily2611.Gauge, tblDaily2611.Temp, tblDaily2611.API,
tblDaily2611.Water, tblDaily2612.Gauge, tblDaily2612.Temp, tblDaily2612.API,
tblDaily2612.Water, (etc...) tblDaily2882.Gauge, tblDaily2882.Temp,
tblDaily2882.API, tblDaily2882.Water, tblDaily2611.Day, tblDaily2612.Day,
tblDaily2613.Day, tblDaily2614.Day, tblDaily2615.Day, tblDaily2616.Day,
tblDaily2617.Day, tblDaily2882.Day, tblDaily2611.*, tblDaily2612.*,
tblDaily2613.*, tblDaily2614.*, tblDaily2615.*, tblDaily2616.*,
tblDaily2617.*, tblDaily2882.*
FROM ((((((tblDaily2611 INNER JOIN tblDaily2612 ON tblDaily2611.Day =
tblDaily2612.Day) INNER JOIN tblDaily2613 ON tblDaily2612.Day =
tblDaily2613.Day) INNER JOIN tblDaily2614 ON tblDaily2613.Day =
tblDaily2614.Day) INNER JOIN tblDaily2615 ON tblDaily2614.Day =
tblDaily2615.Day) INNER JOIN tblDaily2616 ON tblDaily2615.Day =
tblDaily2616.Day) INNER JOIN tblDaily2617 ON tblDaily2616.Day =
tblDaily2617.Day) INNER JOIN tblDaily2882 ON tblDaily2617.Day =
tblDaily2882.Day;

The query isn't updatable but I don't understand why. I have "Day" as my
Primary Key on all of the Tables.
 
Here is the SQL for the query:

SELECT DISTINCTROW tblDaily2611.Gauge, tblDaily2611.Temp, tblDaily2611.API,
tblDaily2611.Water, tblDaily2612.Gauge, tblDaily2612.Temp, tblDaily2612.API,
tblDaily2612.Water, (etc...) tblDaily2882.Gauge, tblDaily2882.Temp,
tblDaily2882.API, tblDaily2882.Water, tblDaily2611.Day, tblDaily2612.Day,
tblDaily2613.Day, tblDaily2614.Day, tblDaily2615.Day, tblDaily2616.Day,
tblDaily2617.Day, tblDaily2882.Day, tblDaily2611.*, tblDaily2612.*,
tblDaily2613.*, tblDaily2614.*, tblDaily2615.*, tblDaily2616.*,
tblDaily2617.*, tblDaily2882.*
FROM ((((((tblDaily2611 INNER JOIN tblDaily2612 ON tblDaily2611.Day =
tblDaily2612.Day) INNER JOIN tblDaily2613 ON tblDaily2612.Day =
tblDaily2613.Day) INNER JOIN tblDaily2614 ON tblDaily2613.Day =
tblDaily2614.Day) INNER JOIN tblDaily2615 ON tblDaily2614.Day =
tblDaily2615.Day) INNER JOIN tblDaily2616 ON tblDaily2615.Day =
tblDaily2616.Day) INNER JOIN tblDaily2617 ON tblDaily2616.Day =
tblDaily2617.Day) INNER JOIN tblDaily2882 ON tblDaily2617.Day =
tblDaily2882.Day;

The query isn't updatable but I don't understand why. I have "Day" as my
Primary Key on all of the Tables.

"RMires" wrote:
Click to expand...

You're trying to join eight grossly non-normalized tables into one
monster query. I'd be REALLY surprised if this can be made updateable
at all!

Storing data in tablenames, as you appear to be doing, is a Bad Idea,
for the reason you're seeing among others. What is different about the
data in tblDaily2612 than in tblDaily2613? Might it not be a whole lot
simpler to have a tblDaily with an additional field containing 2612 or
2613?

And why are you selecting several fields specifically, and then
selecting all those same fields AGAIN using the * operator?


John W. Vinson[MVP]
 
Back
Top