Problem Reported with Access Wizards and 64-bit Access 2010 SP1

Stephen Thomas suggested Using 64-bit Access 2010? You may want to wait on [Installing] SP1 in a 7/8/2010 post to the Access blog:

A customer's post on TechNet brought one of my colleague's attention to an error folks are seeing after applying SP1 to 64-bit Access installations and then trying to use a wizard:

The database cannot be opened because the VBA project contained in it cannot be read. ... To open the database and delete the VBA project without creating a backup copy, click OK.

On clicking OK, Access doesn't open the database, offering this error message:

The code contains a syntax error, or a <DB_NAME> function you need is not available. If the syntax is correct, check the Control Wizards subkey or the Libraries key in the <DB_NAME> section of the windows registry to verify that the entries you need are listed and available.

Apparently, the VBE7.DLL file update included in the service pack prevents the opening of .ACCDE files compiled using RTM 64-bit Access. Because wizards are .ACCDE files, they could trigger the error depending on when they were compiled.

The customer who posted reports that uninstalling the service pack restores the functionality, and advises that people with 64-bit Access wait until a solution is provided before applying SP1. TechNet agrees (the mod marked it as an Answer), and so do I.

Stay tuned for that solution…

Forewarned is forearmed.

---

Technorati Tags: Microsoft Access 2010,Access 2010 SP1,Access 2010 64-bit,Access Wizards,Access 2010 Problems

Office 2010 SP1 on track for late June

Ryan McMinn posted Office 2010 SP1 on track for late June to the Microsoft Access blog on 5/17/2011:

We're on track to deliver Office 2010 SP1 in late June 2011 (here's yesterday's official announcement). We definitely recommend this update for all Office 2010 users. There has been great work put into this service pack that further enhances the performance and security of Access. Here are a couple of highlights:

• Fixed issue in export to Excel to make sure it always export the data based on the current view.
• Improved the performance of publishing client forms from Access with embedded images.

Additionally, if you're one of the few 64-bit Access users working with compiled Access databases (ACCDE, MDE, and ADE files), be sure to check out this KB article that details an update process you'll need to go through to have your files work properly with SP1.

Let us know what you think!

-- Ryan McMinn, Senior Program Manager Lead

Technorati Tags: Microsoft Office 2010 SP1,Microsoft Acess 2010 SP1,Access 2010 SP1

Service Pack 1 coming for Office 2010 and SharePoint 2010

The Microsoft Office Customer Programs Team sent messages to Office and SharePoint 2010 technical beta testers  on 10/26 requesting applications to participate in a forthcoming (calendar year 2010) Beta program for Service Pack 1:

Hello Valued Microsoft Customer,

We are contacting you about an opportunity to participate in an upcoming Beta testing program. You may be a previous tester of Microsoft products, or someone who has been nominated. Beta programs are unique ways to experience product updates and provide feedback to the development teams. Later this calendar year we will begin an invitation-only beta testing of the Service Pack 1 for Office 2010 and SharePoint 2010. Service Packs contain product updates since the product released. We would like to invite you to participate in the private testing of that service pack.

Call to action

If you are interested in participating in this Beta, and if you are already using Office 2010 or SharePoint 2010, please complete the application survey by following the link below. Upon completing the survey, your participation status will be set to ‘pending’, while we review your submission. If you are selected to participate, you will receive a formal invitation to join the program. Due to the limited number of seats in this private Beta, we may not be able to accommodate all interested testers.

If you are already registered on Microsoft Connect, make sure to sign in with your existing registered Windows Live ID account to submit this survey. If you are not registered yet, you will be prompted to do so.

Hopefully, Service Pack 1 will enable Access 2010’s Macro-to-VBA Converter to work with embedded macros. This feature suffered from a regression bug that wasn’t fixed in the RTM version.

Technorati Tags: Access 2010,Microsoft Access 2010,Office 2010,Microsoft Office 2010,Office 2010 Service Pack 1,Office 2010 SP1,SharePoint 2010 Service Pack 1,SharePoint 2010 SP!