Can't add data to Query/Form

[Robbie Doo]

I don't know why my query doesn't accept new data anymore. Here's the SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.

 

[Jeff Boyce]

The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Robbie Doo]

Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I don't know why my query doesn't accept new data anymore. Here's the SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.

 

[Jeff Boyce]

Did you check Access HELP on "updateable query"?

Did you check Access HELP on 'Indeterminate"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked
everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I don't know why my query doesn't accept new data anymore. Here's the
SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA
DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.

 

[Robbie Doo]

Hi Jeff;

I found out that the primary key was removed from the main table. When I put
it back it worked alright.

Thank you for all the help.

Did you check Access HELP on "updateable query"?

Did you check Access HELP on 'Indeterminate"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked
everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP



I don't know why my query doesn't accept new data anymore. Here's the
SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA
DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.