ODBC timeout error

[max2great4u]

Hi,

when I use the below query in the query window it works fine. But when
i try to run the same in a module it gives me a ODBC timeout error, can
somebody help me how to get rid of the ODBC timeout error for the below
code.

DoCmd.RunSQL "SELECT dbo_property_value_bpo.loan_num,
dbo_property_value_bpo.prop_id, dbo_bpo.order_type,
dbo_property_value_bpo.prop_value_id, 'Assigned' AS Type,
Min(dbo_bpo.assign_date) AS [Date] INTO [Prior Days Data] FROM dbo_bpo
INNER JOIN dbo_property_value_bpo ON dbo_bpo.bpo_id =
dbo_property_value_bpo.bpo_id GROUP BY dbo_property_value_bpo.loan_num,
dbo_property_value_bpo.prop_id, dbo_bpo.order_type,
dbo_property_value_bpo.prop_value_id HAVING
(((Min(dbo_bpo.assign_date)) Between #" & oradt & "# And Date()));"

any help in this regard will be greatly appreciated.