AppHangB1 Access

Question

Access stops responding when opening tables (in/with different databases)... the error is below:

(I attempted to post this is the Access forum, but Answers would not allow me that selection)

Any suggestions?

Description:

  A problem caused this program to stop interacting with Windows.

Problem signature:

  Problem Event Name:AppHangB1

  Application Name:MSACCESS.EXE

  Application Version:14.0.4750.1000

  Application Timestamp:4b8bade7

  Hang Signature:8778

  Hang Type:0

  OS Version:6.1.7600.2.0.0.256.48

  Locale ID:1033

  Additional Hang Signature 1:877811919a60c3cb0ab5c729b35d40f7

  Additional Hang Signature 2:dd82

  Additional Hang Signature 3:dd8227a2baa5c87314c1aa0ad63741fc

  Additional Hang Signature 4:8778

  Additional Hang Signature 5:877811919a60c3cb0ab5c729b35d40f7

  Additional Hang Signature 6:dd82

  Additional Hang Signature 7:dd8227a2baa5c87314c1aa0ad63741fc

Read our privacy statement online:

  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:

  C:\Windows\system32\en-US\erofflps.txt

Answer 1

I encountered this similar problem too. Is there a way to solve it?! Thanks.

Answer 2

Have you tried to run a Repair?  What changed or was there some event the preceeded this issue?  What version of Windows?  Are there llinked tables?

---

--

Gina Whipp

Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

Answer 3

Kate:

On your Windows 7 machine, does it have Service Pack 1 installed for Windows?

Answer 4

Kate,

Does the database have any linked images and/or files?  (On the Windows 7 machine this will lead to issues because the file location is different.)

Answer 5

One solution is to use a compatibility

 wizard in the control panel and let it

 figure out the correct settings for the

 older program.

 The below instructions are for Ms Access 2003

 aka Office11.

 Perhaps this method could be used on other

 troublesome programs.

 = = = = = = = = = = = = = = = = = = = = = = = = = = =

When dealing with older Microsoft programs that have

trouble function correctly within Windows-7 64 bit

Professional there is a feature in the Control-Panel

that might help.

That feature used is the System and Security find and fix.

In the case of using Microsoft Access 2003, 32 bit,

under Windows-7, 64 bit, with complex code you can

expect to have AppHangB1 errors, AppCrash errors, or

in the case of early binding to Excel, from Access 2003

VBA, to have the application simply freeze up.

The Steps

1). Open up the Control Panel in View by Category.

2). Search for the ‘System and Security’ topic.

3). Under the System and Security topic select the

    Find and Fix problems item.

4). When the Troubleshooting window opens, select the

    Programs category.

5). Then in the Compatibility window, click the Next.

    That feature will try to guess what program is

    having the problem.

6). In the case of Access 2003, it didn’t show up in

    the list.  Therefore, you will have to click the

    Not-Listed category.  Then click the Next button.

7). A Browse window will appear.

8). Click the Browse button and go to the drive that has

    the application installed on it.  In this case select

    Computer and work your way to the C: drive.

9). Since this is a 32 bit Microsoft application select

    the \Program Files(x86)\ folder.

10). Next select the \Microsoft Office\ folder.

11). Since we are using Office 2003, select the \Office11\ folder.

12). Scroll down until you find the MsAccess.exe program.

     Click it and then click the Open button.

13). You should see ->

        C:\Program Files(x86)\Microsoft Office\Office11\MsAccess.exe

    in the Browse line.

    Click the Next Button.

14). Select ‘Try recommended settings’

15). The Compatibility feature selected ‘XP mode (service pack 2)’.

     Click the Next button.

16). Click ‘Yes, save these settings for this program’, and Click Next.

17). You can also go to ->

       C:\Program Files(x86)\Microsoft Office\Office11\MsAccess.exe

     And do a Right-Mouse Click.

     Select Proprieties, then select compatibility tab.

     Check box ‘Run this program compatibility mode for:’

     And select Windows XP(Service Pack 2).

     Additionally turn on the ‘Run this program as an Administrator’.

     Select the ‘Change settings for all users’ button and Re-enter

     in all the information.

     Then you should be up and running.