Access 2007 SP2 due to ship April 28th

The Office Sustained Engineering team has announced the official ship date. Highlights for Access include:

  • The ability to export reports to Excel has been added.
  • Fixes for issues with the import data wizards, report printing and previewing, macros, Excel integration, and date filters.
  • Updates to Access Developer Extensions and runtime (including as a patch) are now included in SP2.

We will have a complete list of fixes available on the 28th.

Office Blogs Comments

Comments: (23) Collapse

  • Will the updates be retrofitted for the Access 2007 Runtime as well?

  • Renaud--as mentioned above, there will be a runtime patch and updated runtime available around the same time

  • As i remember sometimes the export to excel moves columns, and/or makes columns smaller or wider. Will that also be fixed, or is still the same as the original.

  • Have you fixed the worst bug in ADE? It doesn't add referenced files, like ActiveX, DLLs, etc., into the MSI-file.

  • When should I expect CZ language version?

  • Is this part of an entire Office 2007 SP2?

    It's 28th now, where can I get it?

  • Hmm.. well I tried installing the "Microsoft Office Access Runtime and Data Connectivity 2007 Service Pack 2 (SP2)", on two separate machines that were running the SP1 Runtimes, and all I get is an immediate "The installation of this package failed." message. I tried uninstalling the pre-existing runtime, uninstalled the Save to PDF add-in.. still failed. I then installed the original runtime, and a fresh sp1 runtime, and the updater would still fail with the same message. Am running Win XP SP3 on these machines. I downloaded the SP2 file at: www.microsoft.com/.../details.aspx

  • Oops, nevermind about the above posting. I apparently had gotten a corrupted download.. I re-downloaded it again and it worked just fine.

  • Hi, In new sp2 export report in excel don't work ciao

  • Missing ADE's list of changes in 2007 Office Service Pack 2 Changes.xlsx.

  • Is the fixed file export ever going to be fixed?

  • >Is the fixed file export ever going to be fixed? Can you expand on what this means? The fixed length field option when exporting a text file works just fine for me. Is this a wide known problem? (and has it been reported as a bug/problem?). Albert D. Kallal

    Edmonton, Alberta Canada

    kallal@msn.com

  • >In new sp2 export report in excel don't work I'm able to export reports to Excel with the full version of Access, but not with the SP2 Runtime. The option is disabled in the menus, although I havent tried it through vba yet.

  • >In new sp2 export report in excel don't work I have full version but when I export my report in excel i get error message

  • @Domenico Could you use the contact form and send us your info so we can follow up. @Lee any luck trying it through VBA?

1 2  Next >
Comments

Comments: (loading) Collapse