Office Systems Developer : Workarounds - Fix

Important - Critical Security Information

Joao Livio — Tue, 20 Jan 2009 16:14:00 GMT

PLEASE share with the Public

Dear MVP,

---------------------------------------------------------------------------

Actions Requested:

Win32/Conficker.B/Downadup infections

Please offer these links and resources to members of your community to help mitigate this threat.

MS08-067

Malicious Software Removal tool

History: Win32/Conficker.B

---------------------------------------------------------------------------

Abstract:

Based on feedback from MVPs and other sources, we are concerned about the rise in reported infections due to the worm Win32/Conficker.B also known as “Downadup.” Though systems which have already applied the out-of-band released MS08-067 in October 2008 are protected, unpatched system user have experienced system lockout and other problems.

Last week, we released a version of the Malicious Software Removal tool (MSRT) that can help remove variants of Win32/Conficker and other resources. Please share this information in your communities to help address this threat.

---------------------------------------------------------------------------

Background

Win32/Conficker.B exploits a vulnerability in the Windows Server service (SVCHOST.EXE) for Windows 2000, Windows XP, Windows Vista, Windows Server 2003, and Windows 2008. While Microsoft addressed this issue in October with Microsoft Security Bulletin MS08-067, and Forefront antivirus and OneCare (as well as other vendor’s anit-virus products) helped protect against infections, many systems that have not been patched manually through Server Update Services and Microsoft/Windows Update or through Automatic Updates have recently come under attack by this worm. Attacked systems may lock out users, disable our update services and block access to security-related Web sites:

In response to this threat, Microsoft has:

· Updated the January version of the MSFT to detect and remove variants of Win32/Conficker.B. You can download this version from the MSRT from either the Microsoft Update site or through its associated Knowledge Base article.

· Created the KB article 962007 “Virus alert about the Win32/Conficker.B worm” to provide public details on the symptoms and removal methods available to address this issue.

· Announced the release of the items and the virus threat itself on the Microsoft Malware Protection Center blog.

It is our hope that these resources can assist you in resolving issues with unpatched, infected systems and that you can apply MS08-067 to any other unpatched systems as soon as possible to avoid this threat.

Quando se tenta colar dados directamente do Excel 2007 para o Microsoft Access 2007 é gerado erro.

Joao Livio — Wed, 17 Dec 2008 14:27:17 GMT

Parece que têm havido alguns problemas com a actualização

Security Update for Microsoft Office Excel 2007 (KB958437).

O resutado é um erro quando se tenta colar dados directamente do Excel 2007 para o Microsoft Access 2007

Os dados na Área de Transferência estão danificados, por isso o Microsoft Access não consegue colá-los. / Pode haver um erro na Área de Transferência ou pode não existir memória suficiente. Tente novamente a operação.

Para já não consigo arranjar nenhuma solução, para resolver o problema desistale esta actualização. Vou dando notícias.

Reparar Ficheiros Office - Repair Office Files

Joao Livio — Thu, 30 Oct 2008 19:15:09 GMT

MDB, DBF, XLS, XLW and DOC Files Recover

ENGLISH

I am testing to recover files in format:

Access (MBD) - Until now 0 Offers
Dbase e FoxPro (DBF) - Until now 0 Offers
Excel (XLS e XLW) - Until now 0 Offers
Word (DOC)- Until now 0 Offers

I'am going to offer the first 3 Repairs for each format

Contact: livio@live.com.pt

PORTUGUÊS

Estou a iniciar testes para reparar ficheiros:

Access (MBD) - Até agora 0 ofertas
Dbase e FoxPro (DBF) - Até agora 0 ofertas
Excel (XLS e XLW) - Até agora 0 ofertas
Word (DOC) - Até agora 0 ofertas

Vou oferecer as primeiras 3 recuperações de cada Formato

Contacto: livio@live.com.pt

Office Picture Manager FIX MRU Paths

Joao Livio — Mon, 20 Oct 2008 03:10:00 GMT

offPictManagerFixMRU (Version Beta1)

Feedback is welcome for erros and new features

System Requirements

Windows 2000 SP4/XP (32/64 Bits)

Windows Vista (32/64 Bits)

Office Picture Manger become slow to Open

My Original Article: Here

Download

Download FIX: Here

This patch is provided "AS-IS". Was created by Joao Livio Microsoft MVP Office, i don't work At or For Microsoft, please see http://mvp.support.microsoft.com/. Use it at your own Risk

Microsoft Security Bulletin MS08-057 – Critical

Joao Livio — Tue, 14 Oct 2008 23:24:00 GMT

Microsoft Security Bulletin MS08-057 – Critical

Vulnerabilities in Microsoft Excel Could Allow Remote Code Execution (956416)

Published: October 14, 2008

Version: 1.0

http://www.microsoft.com/technet/security/bulletin/ms08-057.mspx

(Office 2007 BETA) Application Failed to start because MSVCR80.DLL was not found

Joao Livio — Mon, 16 Oct 2006 13:07:00 GMT

Error appear when application stars

Please do not forget at the time this post OFFICE 2007 is still in STAGE BETA.

My intention with this post is to provide a quick workaround to the issue

Seems like Add-ins problems

Let's try this

Go to your EXE Path %Office12%
Rename the "Manifest" file from your applications, e.g. Excel, Outlook..
Try Now

Works?, comment your result.

Office Picture Manager very slow to open

Joao Livio — Sun, 09 Apr 2006 10:37:00 GMT

'(c) 2006 João Tito Lívio
'This code can only be use as a part of an Application and could not be sell

My Office Picture Manager become very slow to open, what to do?

All file paths that are open are stored in this file OIScatalog.cag, so Network paths and other paths may not longer exist, this may cause a Delay when opening Picture Manager, now what to do:

Windows, Windows XP

1. Go to File OIScatalog.cag that is in your LOCAL Profile %\Documents and Settings\<YOUR_PROFILE>\LocalSettings\Application Data\Microsoft\OIS%

2. Look for "MRU PATH" and Delete all paths that your are shure no longer exist, this can be the Goal

Windows Vista Procedures

1. Go to File OIScatalog.cag that is in your LOCAL Profile %\Users\<YOUR_PROFILE>\AppData\Local\Microsoft\OIS%

2. Look for "MRU PATH" and Delete all paths that your are shure no longer exist, this can be the Goal

Revision in: 1/18/2008

Outlook, can not see all messages in Inbox or Folder (Messages Missing)

Joao Livio — Sat, 12 Nov 2005 15:29:00 GMT

Outlook, can not see all messages in Inbox or Folder (Messages Missing)

I can not see all messages in INBOX Folder or a PERSONALIZED Folder, what is happening?

FREQUENT ISSUE: You or someone applied a Filter to Current View option.

WORKAROUND

See Image Bellow

Linked Table Manager is Missing!

Joao Livio — Tue, 30 Aug 2005 21:52:00 GMT

'(c) 2005 João Tito Lívio
'This code can only be use as a part of an Application and could not be sell

Linked Table Manager is Missing!

The file acwztool.mde may be corrupted or is missing

Workaround:

1. Find file acwztool.mde an put it in the MS Access Directory

2. Try Open File maybe or is Corrupted or is from another version of Access.

Follow Steps: http://support.microsoft.com/kb/242218/en-us

E-mail Automation Error "Interface not registered" (All Microsoft Office Sytems Apps)

Joao Livio — Sun, 24 Jul 2005 00:04:00 GMT

'(c) 2005 João Tito Lívio
'This code can only be use as a part of an Application and could not be sell

I get the error E-mail Automation Error "Interface not registered" (All or one Microsoft Office Sytems Apps)

What to do?

Try register this files

regsvr32 OLE32.DLL
regsvr32 MSRDO20.DLL

In adiction from a comment made to this post:

"I couldn't "send page" on Internet Explorer and its working again!"

Office Activation box is "cut", can not see input boxes

Joao Livio — Tue, 10 May 2005 13:01:00 GMT

'(c) 2005 João Tito Lívio
'This code can only be use as a part of an Application and could not be sell

Another workaround to a rare problem but can happen.

Workaround

Hold Shift + Alt and in the upper left corner of the Activation Box, click and hold the right mouse button and drag down to select the text. This should force the bottom of the box to display and be accessible for input

Try more then once if did not result at first time

If this procedure helped, please leave a comment

Microsoft Office 2003 do not generate Activation Key

Joao Livio — Tue, 10 May 2005 06:52:00 GMT

DISCLAIMER - Read First please

USE THIS PROCEDURE IF THE ACTIVATION KEY to Activate your Copy of Office 2003 do not appear. This is not a HACK procedure.

My Office do not generate Activation Key.

Why this happen?. This information is not avaiable but you can try this Workaround, hope it helps

Workaround

1. Go path: %\Documents and Settings\All Users\Application Data\Microsoft\OFFICE\DATA
2. Delete File "OPA11.DAT"
3. try now

If this procedure helped, please leave a comment

Try to Repair a corrupted Database (MDB File)

Joao Livio — Tue, 03 May 2005 01:23:00 GMT

How a MDB get corrupted? WHAT IS GOING ON?

My first thought is, WHERE IS THE “DAM” BACKUP? A project without backups it’s NEVER a good project (In - Joao Tito Livio head, brain cell 165.554), simply there are many ways this happen. This are my suggestions in order to fix this a corrupted MDB file.

Try to repair your MDB in command line mode how? http://support.microsoft.com/default.aspx?scid=kb;en-us;209207

Example: C:\PATH_TO\Msaccess.exe c:\PATH_TO\Database.MDB /Repair

Don’t forget to replace PATH_TO with your PATHS

At this time u may think “This really sucks” but do you have all windows and office updates installed? If not this is my Second suggestion, update windows and office http://windowsupdate.microsoft.com/ & http://office.microsoft.com/en-us/officeupdate/default.aspx. Why? Nothing is perfect I AM NOT

Consider to create a new MDB File and import all Objects with no exceptions. If some object give error DO NOT IMPORT IT, just skip and try to make a new one and copy paste Objects and Code.

Use the JETCOMP utility to fix Microsoft JET; this may be the goal http://support.microsoft.com/kb/q295334 .

Update your MDAC and JET to latest version. http://msdn.microsoft.com/data/downloads/default.aspx

If nothing above produces result, try to get a 3rd Party Utility to fix it.

REMEMBER

A project without backups it’s NEVER a good project. A MBD corrupted may cause lost of Data, hours of work and of course, Money. Make backups of your MDB periodically but DO NOT OVERIGTH in the same version. Keep at least 10 last releases before overnight your project.