ODBC--Call Failed - Collation Conflict

Hi Everyone,

I am fairly new to MS-SQL so excuse my ignorance if I have any.

I am trying to add and link a new table to an existing database. I can add the database and colums and add some data into it, and even run a query on it. However, if I try to run a query using the new table and and existing table (linked) I get the following error:

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation. (#446)

Any ideas?

my Server and SQL specs: SBS2003 & MSSQL ver 8.0what's the query you are executing?|||A Simple or Single Join Query|||post it here.|||Here is the query :

SELECT ChangeCustidLog.NewCustid, Customer.CustId, Customer.CustName
FROM ChangeCustidLog INNER JOIN Customer ON ChangeCustidLog.NewCustid = Customer.CustId;|||try this:

SELECT ChangeCustidLog.NewCustid, Customer.CustId, Customer.CustName
FROM ChangeCustidLog
INNER JOIN Customer ON
ChangeCustidLog.NewCustid COLLATE Latin1_General_CI_AS =
Customer.CustId COLLATE Latin1_General_CI_AS;|||thank you,

the query works fine with the 'collate' phrase, when run in SQL server. I am having trouble when the query runs in Access (and thats where the linked tables are)..

is there a way to fix this 'collate' problem??