query will not work from Access

Windows XP will all the patches. Trying to do a table link from Access to an SQL server. I select the ODBC file data source and get the error “ODBC-call failed”. I can go to a different machine and do the same procedure with the same user sign on and priviledges and it works.
Thanks
Edie