C
cspowell24 via AccessMonster.com
Our office uses Access 2000 as a front end to a SQL
server 2000 database.
Each client has it's own copy of the access .mdb file on
their computer.
It has been up and running for about a year and half but
recently have been getting sporadic ODBC timeout errors.
The syntax of the error is:
ODBC -- update on a linked table 'tableName' failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired (#0)
It only seems to happen in one particular Form when a
user adds/updates a record. The table underneath is a
linked table which has probably 15,000 records This issue
only happens about once every couple of days and is very
sporadic.
I've researched this and seen several postings where people
are having the exact same problem, but I have yet to find a clear
resolution. Anyone, anyone?
server 2000 database.
Each client has it's own copy of the access .mdb file on
their computer.
It has been up and running for about a year and half but
recently have been getting sporadic ODBC timeout errors.
The syntax of the error is:
ODBC -- update on a linked table 'tableName' failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired (#0)
It only seems to happen in one particular Form when a
user adds/updates a record. The table underneath is a
linked table which has probably 15,000 records This issue
only happens about once every couple of days and is very
sporadic.
I've researched this and seen several postings where people
are having the exact same problem, but I have yet to find a clear
resolution. Anyone, anyone?