Try opening the query in design and changing it to Select type instead of
Update - do not save or save as another name.
Run the select query and see if you can edit the records.
Are there any differences in the datatype between the Excel and Access
fields?
I do not think it will help but I rebuilt the query frome scratch - try it.
UPDATE (tblCurrentShow INNER JOIN tblITSBadgeRecords ON
tblCurrentShow.ShowID = tblITSBadgeRecords.ShowID) INNER JOIN ITSBadgeRecords
ON tblITSBadgeRecords.UserID = ITSBadgeRecords.UserID SET
tblITSBadgeRecords.Free = ITSBadgeRecords![Max Exh Comp Full Meeting],
tblITSBadgeRecords.FreeTaken = ITSBadgeRecords![Registered Exh Comp Full
Meeting], tblITSBadgeRecords.Paid25 = ITSBadgeRecords![Max Paid Expo
Only($25)], tblITSBadgeRecords.Paid25Taken = ITSBadgeRecords![Registered Paid
Expo Only($25)], tblITSBadgeRecords.Paid75 = ITSBadgeRecords![Max Paid Expo
Only($75)], tblITSBadgeRecords.Paid75Taken = ITSBadgeRecords![Registered Paid
Expo Only($75)], tblITSBadgeRecords.Pickup = ITSBadgeRecords![Badge Pickup
Instruction];
Amy E. Baggott said:
It didn't help. Does it make a difference if the linked table is an Excel
file (as in this case) or a CSV file (which my other linked tables are)
instead of an Access table?
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
:
I do not see anything wrong with the query.
Try changing the Run Permission property. I do not know if it will make a
difference.
In design view click on menu VIEW - Properties. Then click in the open area
above the grid. Change the Run Permission to User's.
:
UPDATE (ITSBadgeRecords INNER JOIN tblITSBadgeRecords ON
ITSBadgeRecords.UserID = tblITSBadgeRecords.UserID) INNER JOIN tblCurrentShow
ON tblITSBadgeRecords.ShowID = tblCurrentShow.ShowID SET
tblITSBadgeRecords.Free = ITSBadgeRecords![Max Exh Comp Full Meeting],
tblITSBadgeRecords.FreeTaken = ITSBadgeRecords![Registered Exh Comp Full
Meeting], tblITSBadgeRecords.Paid25 = ITSBadgeRecords![Max Paid Expo
Only($25)], tblITSBadgeRecords.Paid25Taken = ITSBadgeRecords![Registered Paid
Expo Only($25)], tblITSBadgeRecords.Paid75 = ITSBadgeRecords![Max Paid Expo
Only($75)], tblITSBadgeRecords.Paid75Taken = ITSBadgeRecords![Registered Paid
Expo Only($75)], tblITSBadgeRecords.Pickup = ITSBadgeRecords![Badge Pickup
Instruction]
WITH OWNERACCESS OPTION;
ITSBadgeRecords is the linked table, and tblITSBadgeRecords is the local
table.
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
:
Your query is trying to update the wrong table - post your SQL.
:
I am trying to run an update query that updates values in a local table from
a linked table that comes from an outside source. The only place the fields
in the linked table appear is in the "Update To" line of the query. However,
when I run the query, I get a message saying that I "won't be able to undo
the changes this action query is about to make to the data in a linked table
or tables." If I say Yes to run it anyway, it then comes back with,
"Updating data in a linked table is not supported by this ISAM."
If I can get this to work with this local table/linked table pair, I plan to
do the same with several other tables that are updated from external data so
I don't have to keep emptying and refilling tables to get the latest data.
