Added a new table to a database and cannot update tables by using queries

[vdspencer]

I have used a database that I created for many years. I had to add a third table to the database and now I am unable to edit the new table through my queries. I can edit things from the two other tables but not the new one. Please help.

[jwhite]

"How" are you unable to edit the table? What steps are you taking to make changes in it?

[vdspencer]

I can edit the table directly, but I need the query to link names with the new table so that I know which data goes with which name. In my preexisting queries and even new queries, i can edit the other tables but not the new table.

[Bulzie]

Post your query SQL code.

[jwhite]

Most likely your query is Non-Updateable due to being too complex. I see this site is a free-for-all with anyone throwing in their responses like wildfire. I leave you to them.

[vdspencer]

Here is the SQL code: SELECT Name.[Active 16X], Name.Sex, Name.Part, Name.[First Name], Name.[Last Name], Attend16.[09/25/16], Attend16.[10/09/16], Attend16.[10/16/16], Attend16.[10/23/16], Attend16.[10/30/16], Attend16.[11/06/16], Attend16.[11/13/16], Attend16.[11/20/16], Attend16.[11/27/16], Attend16.[12/04/16], Attend16.[12/10/16], Attend16.[12/11/16R], Attend16.[12/11/16P]
FROM (Name INNER JOIN Attend08 ON Name.NameID = Attend08.AttendID) INNER JOIN Attend16 ON (Name.Name09ID = Attend16.Attend16ID) AND (Attend08.Attend09ID = Attend16.Attend16ID)
WHERE (((Name.[Active 16X])="Yes" Or (Name.[Active 16X]) Is Null))
ORDER BY Name.[Active 16X] DESC , Name.Sex, Name.Part DESC , Name.[Last Name]
WITH OWNERACCESS OPTION;

[ssanfu]

From the SQL post, this is what I see:

* You have a table named "Name". "Name" is a reserved word in Access and shouldn't be used for object names.
Here is a list of reserved words: http://allenbrowne.com/AppIssueBadWord.html

* You have spaces in object names. Shouldn't have spaces in object names.....
* You have special characters on object names (the "/"). Shouldn't have special characters (nor punctuation) in object names.....
* Your tables have data as field names. "09/25/16" is data. To me, this means you are committing "spreadsheet".

You added another table because you reached the maximum fields in a table limit? Because of the dates as field names, you have 52 fields per year? So 1 table is about 4.5 years??

Committing "spreadsheet" means your tables are designed like a spreadsheet; the table design is not normalized. Having tables designed like spreadsheets causes a lot of problems in the dB (lots of headaches trying to get simple things done).


----------
If you want to post your dB for analysis, make a copy of the dB, delete all of the data, do a "Compact and Repair", then Zip it.