Showing posts with label Office 2007. Show all posts
Showing posts with label Office 2007. Show all posts

Thursday, October 13, 2011

Solution to the problem with PayPal emails in Outlook


Problem with PayPal emails locking up (Not Responding) Outlook?

You may see a message about contacting: \\\b\ss\paypalglobal\1\G.4-NS

Microsoft Outlook 2010 and probably older versions stops responding, freezes or hangs for quite a while.


One solution is to wait.

Another is to turn off the reading pane or just show it as plain text.

A better solution is to add a new line to the host file: C:\Windows\system32\drivers\etc\hosts

Hopefully PayPal will fix this issue with their emails soon.

Monday, August 8, 2011

Asset tracking - JTB FlexReport 6.3 released

JTB FlexReport is an asset management software that can create reports of network license usage and other software usage. JTB FlexReport helps to make purchase decisions with more confidence knowing historically how much your applications have been used.

JTB FlexReport is a report tool for license statistics monitoring of applications using the FlexNet / FLEXlm (flexlm license manager), IBM LUM (IBM License Use Management), SPLM (Intergraph SmartPlant License Manager), SLM/Sentinel LM/Sentinel RMS, LM-X, Solidworks SNL License Manager, Licman, Primavera from Oracle or 12D software licensing as well as any Windows application like Microsoft Office, MS Project, single licensed AutoCAD or AutoCAD LT.

JTB World’s JTB FlexReport has been updated to version 6.3 and adds among other things support for the license system Licman. For more details on the news and fixed bugs see the revision history.

Example of a report showing unique users that on a daily basis are using AutoCAD.

Existing customers with current maintenance (includes support and upgrades) are encouraged to install this new version.

Are you a IT manager, Software manager, IT assets manager, CAD manager or in the position of handling software licenses?

Make your network license management easier, request a free trial of JTB FlexReport. Contact us for a license to activate the time limited fully functional version for a few weeks.

Friday, March 4, 2011

How to Force Outlook PST files to another location

By default Outlook saves PST files in this folder %localappdata%\Microsoft\Outlook\ when running Vista or Windows 7 (%appdata%\Microsoft\Outlook\ for Windows XP).

When it comes to Hotmail and Gmail there is no way from within Outlook to relocate the PST files.

If you for some reason want to move these files Outlook will just recreate them and start downloading your emails again.

But there is a registry hack to force the PST Path. This can either be done before you add the account to Outlook or if you need to move existing PST files. In the later case you need to move the PST files from the default location to the new location as well.

Close Outlook and Locate Outlook in the registry (regedit.exe).

Outlook 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\

Outlook 2007: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\

Outlook 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\

Then create a new Expandable String Value named ForcePSTPath and as value enter the path where you want the PST files to be.

Now start Outlook and the new path should be used.

Monday, May 11, 2009

Windows 7 RC performance benchmark for CAD

According to this test in PC World:

We also measured a noteworthy 7 percent speed increase in our Autodesk 3ds max 8.0 SP3 (DirectX) test on the HP Pavillion desktop, which had an nVidia GeForce 9300GE graphics board. nVidia's drivers appear to be better optimized for Windows 7 than Windows Vista.

My real world experience running Windows 7 RC on a low end and low priced notebook has been very positive compared to using Vista on the same hardware and with the same software (Office 2007 SP2, Visual Studio 2008, SQL Server 2008, AutoCAD 2010, AutoCAD Architecture 2010, etc). I actually can use most of these software at the concurrently up and running something that was not possible on Vista.

I love the boot speed, shutdown speed, general speed in day-to-day usage, lower memory consumption, stability as well as I do like some of the new look and features.

The notebook is an AMILO Pa 2510 with AMD Turion 64 X2 Mobile Technology TL-58 (1.9 GHz), 2GB RAM and an 120GB hard disk with 5400 revs, ATI Radeon X1200 video card and 1280x800 WXGA screen. Have to test a stationary later on. More on this notebok.

I’m pretty sure you get a better performance also on a high end stationary PC.

What is your experience?

Friday, March 27, 2009

Outlook custom toolbars are saved here

Microsoft Outlook stores toolbar information, including any custom toolbars you create, in a file named outcmd.dat. You’ll find this file in the following folder:

C:\Documents and Settings\username\Application Data\Microsoft\Outlook


It’s a good idea to back up this file after you customize the interface. If something goes wrong, you can reclaim missing toolbars by replacing the current copy of outcmd.dat with the backup. You can also use this file to copy custom toolbars to another instance of Outlook.

Windows hides outcmd.dat by default. To view it so you can copy or replace it, you must enable Show Hidden Files And Folders in Windows Explorer by choosing Folder Options from the Tools menu and then clicking the View tab.

Thursday, March 26, 2009

February Cumulative Update for Outlook 2007

The Microsoft Office Outlook February Cumulative Update (CU) contains a large set of the fixes that release as part of the 2007 Microsoft Office suite Service Pack 2 (SP2).

Outlook 2007 SP2 delivers performance improvements in four major areas:

  • General Responsiveness
    SP2 reduces I/O disk usage and UI response time.
  • Startup
    SP2 removes long operations from initial startup.
  • Shutdown
    SP2 makes Outlook exit predictably despite pending activities.
  • Folder/View Switch
    SP2 improves view rendering and folder switching.

Frequently Asked Questions about the February CU and Announcing the February Cumulative Update for Outlook 2007 as well as this article Outlook 2007 improvements in the February 2009 cumulative update

Last word of warning. I have run into some glitches after applying this update with incomplete search results with blank rows at the bottom as well as duplicated rows in the result. But other than that Outlook is indeed quicker and snappier. Now if they just could make search better and quicker.

Thursday, January 29, 2009

Outlook 2007 Not Responding using instant search

I often have problems with Microsoft Outlook 2007 becoming unresponsive when performing a search through the instant search pane.

I can leave it running for 10 minutes and it is still hanged so I need to force it to close and restart it.

My system is Windows Vista and I have tried to disable all add-ons to no avail. I use the latest Windows Search 4.0.

Any ideas how to solve this or track down what the source of the problem is?

Tuesday, December 30, 2008

Compare PDF, DWF, DWFx, DOC, DOCx files

Further on the topic of the previous post but more on to manual compare. DWF Version Compare was introduced in Autodesk Design Review 2008. You find it on the Tools menu. This can be useful when comparing two DWF files. But be aware that it has its limitations like it cannot find differences on raster objects and the DWF files must be the same sheet size and use the same units.

If you want to compare PDF files Adobe Acrobat Professional have that functionality and works great with large multipage documents. Found on the Advanced menu. It’s a real time saver when you get PDF files like specifications from a customer, client or colleague and don’t want to read through everything a second time just to find the changes. Below you can see some of the result from Acrobat compare.

Microsoft Word also have this functionality to compare two versions of a document. I have found not many are aware of it. In Word 2007 it is on the Review tab.

Monday, October 13, 2008

Determine Access Runtime version

The version cannot be seen from within Access Runtime.

To find the version of your Access Runtime you need to go to Windows Control Panel>Programs and Features and look up the Access Runtime or in Windows Vista you can access it from Windows Explorer (ÿ+E) when the Computer is opened via Uninstall or change a program.

You might need to show the Details Pane to see it at the bottom.


Version 2 is having Product version 12.0.6237.1003

Version 1 is having Product version 12.0.4518.1049

Another method is that when it is running look up the process MSACCESS.EXE in Process Explorer and check Properties>Image.

Download to Microsoft Office Access Runtime Version 2.

Tuesday, July 29, 2008

Prevent Excel bloating

Excel has a problem that results in the last active cell can be far away from the last cell with anything in it.

Start with a clean Excel sheet and add some values to it. Press CTRL+End and you will in the case below end up in cell B2.

Now add a value to cell D4. Then delete that value and press CTRL+End and you will end up in cell D4. After using an Excel sheet for quite a while the last active cell could be on a row far far below.

One way is to manually delete the last rows and columns. In the above case deleting column C and D and row 3 and 4.

This can be solved with some VBA code as well.

The code below will solve this on the active sheet. One side effect is that the undo history is wiped out. The code can be run in the Immediate window in the Visual Basic editor (ALT+F11).


Here is a way to do it automatically on all sheets when a workbook is saved.

Private Sub Workbook_BeforeSave _
  (ByVal SaveAsUI As Boolean, Cancel As Boolean)
    For Each ws In ThisWorkbook.Worksheets
    Next ws
End Sub

Monday, July 21, 2008

Access Database Engine Redistributable

If you need to code directly against the Access 2007 database format you can use the Access 2007 database engine that can be downloaded for free.

2007 Office System Driver: Data Connectivity Components

Filename: AccessDatabaseEngine.exe

This download will install a set of components that can be used by non-Microsoft Office applications to read data from 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to Microsoft Windows SharePoint Services and Text files is also supported.

ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

Thursday, July 17, 2008

Outlook signatures folder

Here is a neat trick to open the folder where the Outlook signatures are located.

  • On the Tools menu in Outlook, click Options, and select the Mail Format tab
  • Hold down <ctrl> key while clicking the Signatures… button
  • The folder containing your signatures will open

Via Microsoft Office Outlook Team Blog

Wednesday, April 30, 2008

Find commands in Office 2007 and AutoCAD 2009

You know what you look for in Word, Excel or PowerPoint but cannot find it in the Ribbon. Now with the free Search Commands this is so much easier.

Do you know for example where you can find the command to Insert Form Field?


It is found on the Insert tab and under Quick Parts. Took me a while to find the first time.

Or click on the Search Commands tab and enter "field" and there you have it as well as other related commands.

Hoover with the mouse over any of the results and you find more information including where it is found.

BTW. Similar functionality is included already out-of-the-box in AutoCAD 2009.

And here are the matches using Search menu.


The Microsoft Office Lab Website and Blog. This is another blog to keep a watch on as more useful tools will be released.

Sunday, April 27, 2008

Excel document version created in year 1601

I had one of the rare crashes of Vista and when I fired up Excel next time I notice that the original had this information. Version created last time the user saved the file 1:00 am January 1, 1601". That was some hundred years ago. Call it the Year 1601 bug.

Excel Document Recovery

Thursday, April 17, 2008

Understanding Floating Point Precision in AutoCAD, Excel, etc.

AutoCAD has had 64-bit accuracy in the 32-bit platform for many years but still with 64-bit accuracy things can go wrong with with "unexpected" result.

Why is 1.320 - 1.3190 not equal to 0.001 when it really is 0.001?

Excel caluculation

Be careful when you make comparisons like this.

Both AutoCAD, Excel and many other applications are designed in accordance to the IEEE Standard for Binary Floating-Point Arithmetic (IEEE 754). The standard defines how floating-point numbers are stored and calculated.

A floating-point number is stored in binary in three parts within a 65-bit range: the sign, the exponent, and the mantissa.

1 Sign Bit
11 Bit Exponent
1 Implied Bit
52 Bit Mantissa

A detailed article that describes this thoroughly is Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”

Monday, April 14, 2008

Solution to Outlook.exe keep running after exit

For some time I've run into the problem that Outlook 2007 is not closed fully. The application is no longer visible but the process keeps running as can be seen in Task Manager. It is normal that it can take a few seconds up to some minutes but now it never stops running. And if an email comes during this time I got notified about it and can open that email. If I try to start Outlook it shows the application using the same Outlook.exe process. This happens on Vista SP1 and might happen on other Windows versions as well.

The solution in my case was that I found Skype (version 3.6) locking up Outlook because it was set to "Show Outlook Contacts" in the View menu. When I disabled that option Outlook closed as it should.


One symptom I have seen is that I get the notification that "A data file did not close properly the last time it was used as is being checked for problems. Performance might be affected while the check is in progress."

data file did not close properly notification

Another is this message when starting Outlook could be "Outlook failed to start correctly last time. Starting Outlook in safe mode will help you correct or isolate the startup problem in order to successfully start the program. Some functionality may be disabled in this mode. Do you want to start Outlook in safe mode?"

Outlook failed to start

Then "Data file check in process" can be seen for quite a while.

Outlook Data file check in process

Some other tips if this happens are to check the consistency of the PST files using SCANPST.EXE. Check also for other applications that might connect to Outlook or access the PST files like Google Desktop. Antivirus programs could also be the cause of the locks.

If nothing else works you can try to select "Perform an automatic sen/receive when exiting." in Options>Send/Receive...

Thursday, April 10, 2008

Access 2007 Runtime SP1 available

I have updated the detailed network license reports in JTB FlexReport that can make use the Access 2007 Runtime SP1. Download details are found in this previous blogpost.

Found out about SP1 via the Access Team Blog.

Monday, January 7, 2008

The Email Standards Project

I recently found this website Email Standards Project and think it's a great initiative.

Find out how your email client is doing.

Here are some samples showing how clients like Google Gmail, Lotus Notes 8, Outlook 2007, Windows Live Hotmail and Windows Live Mail ended up in their acid test.


Some companies like IBM and Yahoo! have responded as can be seen on their blog.

Saturday, October 6, 2007

Access 2003 to Access 2007 useful links when upgrading

If you are about to start using or just have started to use Access 2007 these links can be useful.


As a bonus here are some links about the other Office products:

I found out about the interactive guides that helps to find things in the new 2007 ribbon on the Access Team Blog.

If you want help with developing a database or application in Access feel free to contact me. I have many years of experience creating database applications, both small and large. For example one that integrated information flow between CAD, ERP, EDM and more.

Thursday, October 4, 2007

JTB FlexReport Detailed Reports using Access 2007 Runtime

Want to try network license reporting functionality of JTB FlexReport that supports FLEXlm and FLEXnet?

Either contact us for a time limited fully functional version for free or you can use these downloads below and try the reports with a sample database.

Download of JTB FlexReport Detailed Reports that does not require Access to be installed. It uses the Access 2007 Runtime that you will be asked to download and install if needed. The Microsoft Office Access 2007 Runtime allow users who do not have the full version of Access 2007 (or earlier versions) installed on their computers to run JTB FlexReport Detailed Reports. JTB FlexReport Detailed Reports supports older versions but some functionality and reports work better or only in Access 2007.

Download for the Access 2007 Runtime. (56.4 MB)

It seems like the queries for the reports below does not work in all older versions of Access. It works in the 2007 version though.


Download JTB FlexReport Graphic Reports.

Download the sample database with several months data that can be viewed using the reports above.

Documentation is found here. But if you only want to use the three downloads it's suggested that you start installing JTB FlexReport Detailed Reports. It will as default install in the User AppData folder in the subfolder JTB FlexReport. A JTB FlexReport Detailed Reports.mdb shortcut is also created in the All Programs folder on the Windows start menu.
In Windows Vista
%USERPROFILE%\AppData\Local\JTB FlexReport
In Windows XP
%USERPROFILE%\Local Settings\Application Data\JTB FlexReport

Place the two other files in the same folder and correct the path when you start the reports.

Some of the latest blog posts

Subscribe to RSS headline updates from:
Powered by FeedBurner