M
Michael
Hi, All
I am using Access2000 SR1 SP3 + Win2000server SP2+SQL Server 2000 SP1.
I create some linkage tables on access to SQL server, by choosing linking
table by ODBC data source.
I create some sub functions in Model, to open a recordset, and handle it
myself.
These codes most of the time run OK,
but sometimes it pops out a msg window saying:
" Run-time error '3146': ODBC-Call Failed"
I did set the odbc timeout value to "0" for all my queries, which means no
timeout limit, and recordset type as "Snapshot"
How can resolve this problem?
Thanks
Michael
I am using Access2000 SR1 SP3 + Win2000server SP2+SQL Server 2000 SP1.
I create some linkage tables on access to SQL server, by choosing linking
table by ODBC data source.
I create some sub functions in Model, to open a recordset, and handle it
myself.
These codes most of the time run OK,
but sometimes it pops out a msg window saying:
" Run-time error '3146': ODBC-Call Failed"
I did set the odbc timeout value to "0" for all my queries, which means no
timeout limit, and recordset type as "Snapshot"
How can resolve this problem?
Thanks
Michael