AND Cover.song_name = Album.song_name); In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource.

You can’t upsize Access tables that contain dates earlier than January 1, 1953. Use saved queries as opposed to SQL statements as the data sources for Access objects.