Access 2007 Runtime SP1 is now available

I know lots of you are very anxious to get your hands on this build. You can go download the SP1 runtime.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

This version of the Access 2007 Runtime contains files whose versions are slightly higher than the level of the same files that are updated by Office 2007 Service Pack 1 (SP1). For additional information about Office 2007 Service Pack 1 and the Access 2007 issues fixed by Office 2007 Service Pack 1, click the following article numbers to view the article in the Microsoft Knowledge Base:


936982 Description of the 2007 Microsoft Office suite Service Pack 1
942378 Issues that are fixed in Access 2007 by the 2007 Microsoft Office suites Service Pack 1


The Access 2007 Runtime updates files to correct some specific Access 2007 runtime issues that were not previously documented in a Microsoft Knowledge Base article:

  • PDF/XPS Export: You may see a message similar to "can't save the output data to the file you've selected" or "The OutputTo action was cancelled", when you try to export an object to the PDF or XPS file formats from within Access 2007 Runtime.
  • Text/HTML Export: You see a message similar to "can't complete the Output operation" when you try to export a report to the Text or HTML file formats from within Access 2007 Runtime.
  • Pivot Table/Chart Views: Pivot Charts and Pivot Tables do not show the correct results when opened in Access 2007 Runtime.
  • Access Data Projects: You see a message similar to "The record source [RecordSourceName] specified on this form or report does not exist", when opening a report in an Access project (*.adp) which is bound to a SQL Server object even though the record source exists.
  • Trusted Locations: the database folder is added to the trusted locations ensuring the application will run without secuirty warnings.

The international versions of the runtime should be available in the next few weeks (I don't have a specific date as intl testing is ongoing). We will post download links as they come available.

Enjoy!

Edited 4/8/08 to include mention of trusted locations.

Office Blogs Comments

Comments: (25) Collapse

  • Thanks Microsoft for your help and continuos support. You can imagine my surprise when i saw the blog, i know all is going to start working now. Again thanks for your help.

  • i see that it says Access Runtime is now available, that guide me to a question :-) Is this a new release of the runtime? or is like an SP1 of the runtime? Do we need to install to update the runtime our clients have, or this will install like a complete verssion without the initial runtime? Will this support the next office service packs, when new service packs become available will they update the access runtime or we will need to manually update our clients? I need to know a litle bit more of this important update for us. Thnks again for your help.

  • I have just tried it: Appearence is better but you need to uninstall the previous runtime before installing the new one. Garry

  • Is the runtime supported on Windows 2000?

  • I'm happy !

    Je suis content ! From France

  • Thanks!!! Great - just tested it out and everything works fine! helmut

  • An important question that I cannot find the answer to in any of the documentation of the runtime or this update. Will the runtime ever be aligned with access/office such that it receives updates anytime regular Access 2007 would receive updates via AutomaticUpdates/MicrosoftUpdates/SUS/etc? If the answer to the above is no, will updates to the runtime be distributed automatically at all via MU/WU/SUS/etc? Thanks, andrew

  • Still does not "Save as" PDF if the complete office version is not installed...same dialog (and crash) as before. Have I done something incorrectly? I removed the previous version of AccessRuntime and installed version 2.

  • Further to my previous post; I misspoke too soon! The "Save as" PDF hasn't worked for so long that I forgot (maybe never knew??) that the "SaveAsPDFandXPS.exe" (and variants) had to be installed on the system. Thanks, it does function as advertised.

  • Thank You so much for this update.

    One question though. On machines with access runtime there is no option to change the color of interface (Blue, Silver, Black). Is there any kind of possible workaround?

  • How to change the runtime color: 'vbscript

    Set WshShell = WScript.CreateObject("WScript.Shell")

    'Black Theme WshShell.RegWrite "HKCU\Software\Microsoft\Office\12.0\Common\Theme",3,"REG_DWORD"

  • Guys the runtime works fine, and faster than the previous runtime, thanks for your good work. Clint and Zach!!

    There is something that is bothering my head for some time, I saw that excel has a new and improved conditional formatting that supports additional icons and stuff like that, and has more than 3 rules like the old excel.

    What we have is the old excel feature, the access developers have been fighting with that problem since version one of access.

    I think most access developers fight with that problem and have to use other 3rd party controls like grid and stuff like that.

    Now, if excel have it, why can we the access community.

    My friends . . .

    Please make that feature available to us the access community, and we will live you guys more than ever. Edwin

  • Pile of thanks to all the MS guys who made this happen. This is probably the most important event so far this year. Edwin's points a good one btw. The lack of elaborate conditional formatting (or simple things like 'highlight current row'), and the inability to have much control over continuous forms, mean we're often reaching for grids...

  • So, since the runtime requires Removal of the previous one vs it auto-upgrading, how can we initiate a removal. I do not want to have all of my users go in and have to use Control Panel To remove the previous version. This should have been either a patch, or as a full-install to automatically remove previous version. Is there a command line option to have it remove the previous version so we can automate the installation of the new version. come on guys, you work so hard finally fixing runtime and then you make it hard for users to install. Most of my users do not know how to even get to the control panel.

  • I would also like to know if this new sp1 runtime has the fix included in it that is part of kb936982

1 2  Next >
Comments

Comments: (loading) Collapse