M
Microsoft News Groups
I have two databases written in Access2000 with SQL server 2000 backends.
In the last couple of days several forms are coming up with "ODBC error on
linked table: Timeout" errors.
I have relinked the tables
The error occurs when
usingDoCmd.RunCommand accmdSaveRecord
using a SQL statement like
CurrentProject.Connection.Execute "Update tablename Set field = value
Where Index = Ivalue"
or
using a SQL Server stored procedure with parameters @field and @Ivalue
and ADO connection and command objects and calling command.Execute
The error does not always occur.
Data can be changed in the linked tables when opening the tables in the
Tables 'tab' of Access.
The error seems to be related to updating rather than creating rows in the
tables.
Any suggestions would be greatly appreciated.
Rod Scoullar
In the last couple of days several forms are coming up with "ODBC error on
linked table: Timeout" errors.
I have relinked the tables
The error occurs when
usingDoCmd.RunCommand accmdSaveRecord
using a SQL statement like
CurrentProject.Connection.Execute "Update tablename Set field = value
Where Index = Ivalue"
or
using a SQL Server stored procedure with parameters @field and @Ivalue
and ADO connection and command objects and calling command.Execute
The error does not always occur.
Data can be changed in the linked tables when opening the tables in the
Tables 'tab' of Access.
The error seems to be related to updating rather than creating rows in the
tables.
Any suggestions would be greatly appreciated.
Rod Scoullar