I have a Access 2003 VBA module that loads the data of some SQLServer db tables, to a Access 2003 table, via a ODBC connection.

I am having problems with a data field relation, most of the records are unmatched in an SQL relation Query (example)
select count(*) from [Errores de C5] where accountID = "SQLServer Key Field"
(the query is executed in a VBA module from the self Access 2003 db)

The SQLServer field is uniqueidentifier type (example value)
{0003E71C-A17F-4BCB-94F1-4DD2372F503F}

I don't have the option of changing the SQLServer data type, but the Access 2003 database would be changed at my wish.

I have tried with Text, Numeric, and Replicationid data types in Access, and the result is the same. only 3 of a total of 2732 records are correctly founded.
Please, what data field type should I choose, or what can I do?

Have you tried building two separate queries and then joining the two queries to acquire the results you are looking for.