Jim Lawrence
accessd at shaw.ca
Fri May 7 12:42:34 CDT 2010
Hi John: It is a timing / time out issue. Either extend the connecting time-out or force a loop and retry if the appropriate connection is not established on first pass... have done that for years.... very typical. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, May 07, 2010 8:01 AM To: Access Developers discussion and problem solving Subject: [AccessD] SQL Server "wakeup" mystery Guys, I got the following in an email from a customer. Does anyone have any ideas? >John - For the past 3 months (or so) there seems to be a problem regarding the access to the check info that resides on the SQLSERVER on PSSERVER. >The pattern we seem to be seeing is that the first time someone tries to access the check info in DISCO the check screen fields display "?????" . When They get out and go back into it again the check info is present. Then for the balance of the day all is fine. >John says he has a similar problem when running reports from PSSERVER. He initiates the report, it hangs, he kills it, then reruns and then it is OK. >It just appears like there is a "wakeup" issue going on when anyone initially access the SQLSRVR on PSSERVER. -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com