Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.
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.

Posted: Friday, March 28, 2008 3:41 PM by Clint Covington
Filed under:

Comments

Edwin Blancovitch said:

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.

# March 28, 2008 7:01 PM

Edwin Blancovitch said:

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.

# March 28, 2008 7:08 PM

Access said:

Acaban de hacer el anuncio en el "Access Team Blog ". La mala noticia es que aún hay que esperar

# March 28, 2008 7:11 PM

Garry said:

I have just tried it:

Appearence is better but you need to uninstall the previous runtime before installing the new one.

Garry

# March 28, 2008 7:24 PM

anon said:

Is the runtime supported on Windows 2000?

# March 29, 2008 6:43 AM

Naphta said:

I'm happy !

Je suis content !

From France

# March 29, 2008 2:20 PM

helmut said:

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

helmut

# March 29, 2008 3:03 PM

Andrew H said:

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

# March 29, 2008 6:02 PM

Ivan said:

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.

# March 29, 2008 7:35 PM

Ivan said:

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.

# March 29, 2008 8:21 PM

Donatas said:

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?

# March 30, 2008 8:01 AM

JibberSki said:

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"

# March 31, 2008 2:52 PM

Edwin Blancovitch said:

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

# March 31, 2008 4:33 PM

James Beswick said:

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...

# April 1, 2008 12:02 PM

M. David Matney said:

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.

# April 1, 2008 2:40 PM

M. David Matney said:

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

# April 1, 2008 2:42 PM

M. David Matney said:

Lastly, can we get a posting of KNOWN problems, so we don't deply and then find out "ooops, did we do that?"

# April 1, 2008 2:43 PM

Viastar said:

Does this fix also kb946205 error? http://support.microsoft.com/kb/946205/

# April 2, 2008 11:47 AM

M. David Matney said:

Viastar, thank you for the link to the KB article, but the link doesn't asnwer the question.  Im very well aware of the link.  

The issue is.  Microsoft issued a Hotfix named: office2007sp1-kb936982-fullfile-en-us.exe and this hotfix if applied corrects a known bug whereby access goes into repeated loops when drawing the display.

It was communicated by Microsoft, that applying the above referenced file will correct the problem, however future service packs will overwrite the hotfix and thus the problem will return.  

my question is related to whether or no the SP1 runtime includes or excludes the hotfix described above.  If it includes it, then it will not effect anything. If it excludes it, then we have to apply not only the SP1 runtime, but ALSO the hotfix AGAIN.  

So again, thank you for the link, but that does not answer my question originally. asked about whether the SP1 Hotfix includes the update from KB946205 or maybe more specifically, the update that was part of office2007sp1-kb936982-fullfile-en-us.exe

# April 2, 2008 12:17 PM

Clint Covington said:

David, all the fixes included in sp1 are referenced in the spreadsheet available on this kb article describing what was included.

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

Folks are working on a follow up blog that answers some of the questions asked above. Give us a couple days to round up all the answers.

# April 2, 2008 10:44 PM

Salom said:

I can't  use Access 2007 for my customers (full or runtime version). Access with SP1 has one big problem (like before SP1) crashing after use righ click - permanently! Can you fix this essential problem? Thank's and sorry for my horrible English.

# April 3, 2008 9:20 AM

Clint Covington said:

Salom,

I haven't seen the issue you are describing in SP2. I don't see your crash on my machine and it hasn't turned up as a top issue in our crash reports. I suggest that you work with our support team to narrow down the issue and get us an in-house repro. There shouldn't be a charge for support if it turns out to be a MS bug.

http://support.microsoft.com/oas/default.aspx?gprid=11265

# April 3, 2008 11:15 AM

Salom said:

You mean SP1 not SP2?

I have this problem under vista and under win XP SP2. When you put in google "access 2007 crash after use right click" you can see - this is not only my problem. Here is too.

I can send my aplication, where is this problem - to analysis. Under access 2003 is all ok.

# April 3, 2008 11:42 AM

Clint Covington said:

Sorry, Access 2007 SP1.

http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

There is a spreadsheet in the following kb article:

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

I think you will find a link to a fix for right click crashes. Try installing SP1 and see if that doesn't fix your issue.

Have a great day.

# April 3, 2008 2:49 PM

Salom said:

I have SP1 install and i have runtime 2007 SP1 on my virtual PC install. But my problem still continue.  See - Salom said on April 3, 2008 9:20 AM: It is same like before SP1. :-(

# April 3, 2008 3:03 PM

Edwin Blancovitch said:

Clint and zac . . .

i have adopted the report view for my apps, because it allows me to identify one record at runtime among other bennefits, and that is great for analisys, however if i use report view i loose the zoom, to 150, to 100, to 75, to 50 . . .

No problem, how do i change from report view to print preview at runtime, when users are using the runtime.

what is the command to do that?

and i think you need to verify something, when i have very complex reports, with some subreports on it, and we click find (ctrl+f) in the report access just crash.

can you please check that for me, and tell me any ideas or workarrounds.

# April 4, 2008 4:06 PM

beqiraj.net said:

Access 2007 Runtime and Access 2007 Developer Extensions

# April 8, 2008 5:19 PM

beqiraj.net said:

Access 2007 Runtime and Access 2007 Developer Extensions

# September 29, 2008 5:11 PM
New Comments to this post are disabled
Page view tracker