Likely cause of Access Error? -- attempting to update Table A from corresponding Table B value

Factual Questions
21

I think I need to wait for internal help from someone who knows WTF they’re doing. I wasn’t hired to be an Access developer.

22

Yeah, this.
Import into a non-linked table.
You can always export that as a .csv if you need to.

23

FWIW, I tried the following SQL in a trimmed-down mimic of your tables, and it updated the appropriate rows.

UPDATE 
    GoatOutPrograms 
    INNER JOIN Programs 
        ON GoatOutPrograms.Program_IDx = Programs.Program_ID 
SET 
    Programs.Latitude = [GoatOutPrograms].[Latitude], 
    Programs.Longitude = [GoatOutPrograms].[Longitude];

I think the issue is either the linked table or expecting NULL values in the Programs table.

24

I agree. I asked OP to check the actual values in Programs.Latitude to make sure they’re truly NULL for the records OP’s expecting to be updated. Maybe Access is “hiding” zero-values in those columns? Just a blind guess.

25

Nope. I exported the Access table to CSV and converted it to FileMaker, isolated the records empty on the coordinate fields, populated them by a script that scraped a web site, then exported them back out.

MY guess is that they gave me more limited editing powers than they think they did, or the table is protected from being overwritten in any way aside from manual entry or some such thing.

The simple update query (the one that doesn’t make any reference whatsoever to the new GoatOut table and just tries to UPDATE a Programs record without refence to whether or not any column value is NULL or not) fails. It shouldn’t, I think, and the fact that it does makes me uninclined to futz with it further until someone with Access chops in our company investigates.

26

My guess too…