When Microsoft Windows asks a program to do something, like take a keystroke or close itself, and the program fails to acknowledge that request within a certain amount of time, the program is said to be “Not Responding” according to Windows. If the program never comes out of that state, we might also call it “hung”, as in “hung up” on something. Most of the time, however, the program is working and writing data to its database, though other factors may slow it down. When Windows detects that “nothing” is happening within a time period that Windows itself deems reasonable, it will often put the words “Not Responding” in the window frame of the application.
The reality is that most Windows programs of late, especially those that have SQL database foundations and/or maintain a central database are often “responding” albeit slowly. For example, when a software product is given a command by a user, depending on the command sent from the workstation, over the network to the database, it may often take more time to complete its transaction or “call” to the database than “normal”, and Windows will trick the user into thinking that the application is hung by placing “not responding” in the windows frame of the application. The problem is that when the end user believes the application is hung, and thereafter forces a software product to close, often times, the data that is being written to the database is incomplete. In those circumstances, impatience is your worst enemy and forcing the application to close may cause your database to become unstable because the application was not able to complete its “write” to the database.
The better practice is to simply be patient. Thereafter, take a look at some key factors in your own network including, network folder rights (do you have full access to the database folder on your server), is your equipment older and has it been properly updated and maintained, have you recently changed anything significant on your network, have you added or updated a new virus detection software program, etc?
Remember, in the scientific equation of software and hardware, the hardware is the variable and the software is the constant. In other words, the software typically runs on thousands of other systems, the hardware and network is unique to your firm or business.