Linked Server object cannot be used as a destination with this query type.
From Microsoft Office Access 2003
Linked Server object cannot be used as a destination with this query type.
The selected query type does not support using linked server objects as destinations.
For more information, see About Creating Queries.