D
David
Hi
We have an application with Access 2K ade frontend and SQL Server 2K
backend. Its been running fine on several sites for a couple of years. Now
one site has developed weird hang-up. Each morning, users can't log in to
application - the stored proc that validates the users gets a timeout
(immediately).
The ade has a File, Connection set up and the test connection returns OK.
If one user opens the ade with the shift key down, opens a table and
modifies the data directly, then everything clicks into life and everybody
can login and use system.
Occasionally system stops during the day. This has been happening
I've had a brief look for SQL locks but can't see any problem. There have
been somne network topology changes on this site but the network people say
it's fine - well they would woun't they.
I really need some clues as to where to start investigating this.
David
We have an application with Access 2K ade frontend and SQL Server 2K
backend. Its been running fine on several sites for a couple of years. Now
one site has developed weird hang-up. Each morning, users can't log in to
application - the stored proc that validates the users gets a timeout
(immediately).
The ade has a File, Connection set up and the test connection returns OK.
If one user opens the ade with the shift key down, opens a table and
modifies the data directly, then everything clicks into life and everybody
can login and use system.
Occasionally system stops during the day. This has been happening
I've had a brief look for SQL locks but can't see any problem. There have
been somne network topology changes on this site but the network people say
it's fine - well they would woun't they.
I really need some clues as to where to start investigating this.
David