Access 2007 hangs/stops responding (43361 Views)
Student
Yamaeda
Posts: 1
Member Since: ‎03-01-2011
Message 31 of 45 (3,922 Views)

Re: Access 2007 hangs/stops responding


jjanoian wrote:

Finally, after taking 8 hours to de-encrypt my hard drive so I can remove the HP encryption tool and remove the HP Support tools, I now have an MS Access program that I can actually use.  


You only need to disable the finger print service. :smileyhappy:

/Yamaeda

Student
Vxed
Posts: 1
Member Since: ‎03-29-2011
Message 32 of 45 (3,804 Views)

Re: Access 2007 hangs/stops responding

I just installed a new HP Compaq 8000 Elite-PC at a clients office that had this problem. I tried first to run it as administrator and that worked fine, didnt go with that solution though as end users shouldn't have to remember stuff like that.

 

Uninstalled the HP ProtectTools Security Manager as they didn't use this software anyway, solved the issue straight away.

 

Might be an update for the HP ProtectTools Security software that resolves this issue but didn't bother looking for one.

Honor Student
Riel
Posts: 3
Member Since: ‎05-02-2011
Message 33 of 45 (3,627 Views)

Re: Access 2007 hangs/stops responding

I have found the conversation about Access database hanging very useful, because I have been struggling with the same problem for a while now after buying a new HP laptop. Could you just please tell me how to disableuninstall the HP Protect Tools Security application?

Thanks.

Honor Student
Riel
Posts: 3
Member Since: ‎05-02-2011
Message 34 of 45 (3,626 Views)

Re: Access 2007 hangs/stops responding

Sorry, my previous post should have read "diasable/uninstall".

Honor Student
Rudiau
Posts: 2
Member Since: ‎05-30-2011
Message 35 of 45 (3,446 Views)

Re: Access 2007 hangs/stops responding

I know this thread is old, but if it helps.....

Two issues that i have struck.

1) Running Access as Admininstrator "fixes" the tables not populating problem

 

2) Suspending or stopping the WLAN Auto Config in Services "fixes" the "Not Respnding" problem in design mode.

 

HP Pavilion DV6 3131TX

Win 7 Home Premium

MS Office 2007 Enterprise

 

Thinking of upgrading to Win 7 Pro to see if that works.

Student
davidc707
Posts: 1
Member Since: ‎08-08-2011
Message 36 of 45 (3,089 Views)

Re: Access 2007 hangs/stops responding

I too am having this problem. Even uninstalled microsoft and re-installed but no luck. Can anyone help?

Honor Student
brentmack
Posts: 2
Member Since: ‎08-23-2011
Message 37 of 45 (2,982 Views)

Re: Access 2007 hangs/stops responding

I solved this 3 year long problem with the following batch file (after reading the above comments):

 

@echo on
rem biometric authentication service temporary removal
sc stop dphost
pskill dpagent.exe
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
sc start dphost


This batch file stops the service and the task that causes Access to hang.

It then starts Access. (the batchfile command window will remain open)

Once you finish and close Access, the batch file restarts the service, and closes itself.

 

If you don't know what sc.exe or pskill.exe are, just google them.  Works like a champ, and keeps my finger print reader working!  I no longer want to take a hammer to my machine.  ;-)

 

 

Student
Heinrich85
Posts: 1
Member Since: ‎11-24-2011
Message 38 of 45 (2,489 Views)

Re: Access 2007 hangs/stops responding

I have tried the below on my HP Pavilion Entertainment PC, but do not work on my HP ProBook 4520s, any suggestions or different Batch File to use?

 

@echo on
rem biometric authentication service temporary removal
sc stop dphost
pskill dpagent.exe
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
sc start dphost


This batch file stops the service and the task that causes Access to hang.

It then starts Access. (the batchfile command window will remain open)

Once you finish and close Access, the batch file restarts the service, and closes itself.

Honor Student
brentmack
Posts: 2
Member Since: ‎08-23-2011
Message 39 of 45 (2,482 Views)

Re: Access 2007 hangs/stops responding

The batch file is still working fine for me, and I'm glad it works on one of your machines. It's odd that a fingerprint reader could hang ACCESS, but temporarily removing the reader was the only solution for my machine.  For your ProBook, I'd suggest removing any programs or services that drive special features of the ProBook, and see if ACCESS works ok.  It's seems hit-or-miss, but just keep experimenting.

Honor Student
JohnOtto
Posts: 1
Member Since: ‎01-21-2012
Message 40 of 45 (2,227 Views)

Re: Access 2007 hangs/stops responding

I too have experienced the the problem of MS Access hanging when opening a table that is bigger than the window but smaller than 231 records. This started when I upgraded from MS Office 2003 to MS Office 2010 on my HP dv7-4190us computer. This thread helped me identify the problem but I seem to have found an easier fix than I've seen on the thread.

 

The problem went away when I changed the settings on the fingerprint reader. I unchecked the "Prompt to add logons for logon screens" and that is all it took to get a fully functioning MS Access again! I don't even have to shut down.

 

It also works to disable the fingerprint reader with MSConfig.exe or to stop the Processes by DigitalPersona with Task Manager.

 

I believe it also improves the performance of an MS Access form opening in another database.

 

My configuration:

HP dv7-4190us with Windows 7 64bit home. It appears that the only DigitalPersona software is related to the fingerprint reader.

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation