Appending to Sharepoint List From Access

Hey guys,

I have 2 lists each on their own Sharepoint Site. I have them both linked to
my Access Frontend. They both have the same permissions. I'm able to write an
append query to one of the lists but not the other. What happens is when I go
to select 'Append Query' from the tool bar, the name of the linked sharepoint
list is not an option in the "Append To" drop down menu. Does anyone know
what the culprit could be and sorry if I didn't write this in the correct
forum.