Append Query to a Linked Table

[Erika]

I have a linked table and I am trying to create an append query to update it
and it is not working. The table is actually a paradox table, I am working
with Access 2007 anyone have any ideas?

 

[TedMi]

Please be more specific by what you mean by "it is not working". Post your
query, and any error messages it generates.
-TedMi

 

[Erika]

Nothing happens, there is no error message and the new information is not in
the table:

INSERT INTO dbo_ldTempCallList ( ld_AcctNo, ld_CompName, ld_Group12,
ld_SalesRep, ld_Trucks, ld_Trailers, ld_NoEmply, ld_Drivers, ld_GrpStats,
ld_BuyerNo, ld_OrderDate, ld_ProductCode, ld_Description, ld_ContactName,
ld_Units, ld_Rev, ld_List_ID )
SELECT [Forms optimum reorder detail].[Acct #], [Forms optimum reorder
detail].[COMP-NAME], [Forms optimum reorder detail].GROUP12, [Forms optimum
reorder detail].SALESREP, [Forms optimum reorder detail].TRUCKS, [Forms
optimum reorder detail].TRAILERS, [Forms optimum reorder detail].[NO-EMPLY],
[Forms optimum reorder detail].DRIVERS, [Forms optimum reorder
detail].[GRP-STAT], [Forms optimum reorder detail].[BUYER-NO], [Forms optimum
reorder detail].[ORDER-DATE], [Forms optimum reorder detail].[Product Code],
[Forms optimum reorder detail].DESCRIPTION, [Forms optimum reorder
detail].CONTACT, [Forms optimum reorder detail].UNITS, [Forms optimum reorder
detail].REV, [Forms optimum reorder detail].listid
FROM [Forms optimum reorder detail];