I have a SQL Server 2000 database hosted by a comercial hosting
company. On my customer's PC, I have a Microsoft Access 2002 project
(.adp) running under Windows XP that connects to the database via a
DSL Internet connection.
The Access project invokes a stored procedure in the database to read
a field in a table every 2 seconds. The same Access project VBA code
invokes the same stored procedure to read the same field in the same
table for about 9 hours a day, 7 days a week.
Everything has run pretty well for the past several months, but about
twice a week an error of one type or another occurs.
The following is a list of the various Microsoft Access error numbers
and error descriptions that I have received in my logs over the past
several months while the application has run:
3265 - Item cannot be found in the collection corresponding to the
requested name or ordinal.
-2147467259 - Timeout expired
-2147467259 - [DBNETLIB][ConnectionRead (recv()).]General network
error. Check your network documentation.
-2147467259 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied.
3705 - Operation is not allowed when the object is open.
-2147467259 - Data provider could not be initialized.
Tech support at the hosting company said the most likely cause for
these problems is "MS Access hang." Does anyone have any thoughts
about the cause and/or solution to the problem?
Thanks for the bandwidth.
|
Similar Threads
