Dlookup and collation issue?

[Guest]

Hi all.

I am running an Access 2002 SP-2 adp that is connected to a SQL Server 2003
backend database. This database has a non-default collation of
"Arabic_CI_AS". I am continually encountering a "connection failure" error
when trying to open one of my forms within the adp. The code seems to be
breaking on a dlookup function which is passing an integer value and
returning a string value. I have set the field referenced by the dlookup
function to be collated the same as the database as well as the server
default, "SQL_Latin1_General_CP1_CI_AS". In both instances I still encounter
the connection failure error. Is there a workaround to this issue?

TIA.

-Ted

 

[Mark A. Sam]

Hello Ted,

I haven't used ADP's and don't know your implementation, but I would try
assigning the value of the DLookup to a variable and use the variable to
pass the value to the SQL server.

God Bless,

Mark