Access 2010 SP1 – You receive random crashes in certain database or when opening the VBA window in those databases after installing Office 2010 SP1

Another Citrix User for Access 2010 applications here. Thanks for your information!

Would you be so kind as to provide your general specifications for both your server and development station?

e.g. Windows 2008 32 bit OS, Office 2010 32 bit  / Windows 7 32 bit, Office 2010 32 bit

My first deployment of Access on Citrix was in 1998. It is a great way to go for dial-up customers.

Today, the opportunity to link Access applications to Share Point 2010 from a server deployment sound promising.

B.T.W. - Any estimates about the schedule of SP2 (assuming things continue to go well)?

Hi Nathan

I think I finally worked it out

Although I have a PC,  our network runs on citrix  via a thin client terminals.

I am the guinea pig for the hotfix, so I have downloaded and installed the correct hotfix onto my PC only.

When I open VB in an access database on the network it crashes

But if I copy the Database to my PC, VB opens ok.

I should have realised that if I open a database on the network it will use the citrix published Access not my PC Access - duhh

we will go ahead and install the hotfix on the network

thank you for your help

Having looked through this thread, you deserve a pint !!

regards

John

Thank you for your  prompt response.  The 32bit hot fix installed without a problem and I now have the correct verstion of vbe7.dll

Jeffrey Morton

Hi Jeff,

As mentioned in a previous post, the hotfix site detects the bit version of your operating system and presents you with a hotfix in that bit version.  You most likely are running a 64 bit operating system and have the 32 bit version of Office 2010 installed (which is common and recommended).  In order to get the proper bit version of the fix, you can do the following when you open the KB that discussed the hotfix:

Description of the Access 2010 hotfix package (Access-x-none.msp): October 25, 2011

http://support.microsoft.com/kb/2596585 

1.      In the upper left corner of the article click “View and request hotfix downloads”

2.      If prompted, click the “I Accept” button for the Agreement for Microsoft Services.

3.      On the Microsoft Support Hotfix Request page, click “Select hotfix”

4.      Click the link “Show hotfixes for all platforms and languages…”

5.      If you installed the x32-bit version of Office, select the “x86” Platform version of the fix.

If you installed the x64-bit version of Office, select the “x64” Platform version of the fix.

To check the platform version of your Microsoft Office 2010 application, follow these steps:

1. Open your application.

2. Click the File tab

3. Click Help

On the right side, you will see a version number in the following format:

14.0.####.#### (##- bit)

If the application version number ends with “(32-bit)”, select the hotfix version that contains “x86” in its number.

If the application version number is followed by “(64-bit)”, select the hotfix version that contains “x64” in its number.

Note that the Hotfix site detects your Internet Explorer and operating system platform version and automatically chooses the version of the hotfix based on the version of Internet Explorer and your operating system rather than on the version of the Microsoft Office 2010 application that you want to fix. If your Internet Explorer and operating system platform version (x64 vs. x32) is different from your application version, you need to make sure to select the correct platform version of the hotfix for your application.

4.      Provide your e-mail address, enter the characters as shown and click “Request hotfix”

5.      You will receive an email from hotfix@microsoft.com that provides you the link to the fix. Click the link.

6.      Click “Run” when prompted.

7.      Click “Continue” in the Microsoft Self-Extractor window.

8.      Type the name of a folder or browse to the folder in which you want to save the hotfix and click “OK”.

9.      Click “OK” to the message that All files were successfully unzipped.

10.  Navigate to the folder where you saved the fix. Double click on the file you just extracted. The file name should include the number of the Knowledge Base article that described the fix.

If you attempt to install the 64-bit version of the Microsoft Office fix on a machine that has the 32-bit version of Office, you will receive a message similar to:

“There are no products affected by this package installed on this system”

I hope that helps.

Best Regards,

Nathan O.

Microsoft Online Community Support