Blackforce

If Microsoft Access 2003 keeps saying preparing to install everytime you load it just import this file into your registry.

http://cl.ly/DtZZ

Job done

Most of the times its located in :

C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

If it needs shrinking do the following :-

Backup the database using SQL Management. Connect to the instance using

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

as the server name.

Once backed up right click on the Database Sharepoint Config and click new query.

Execute each of the following querys in turn

BACKUP LOG [Sharepoint_Config_blahblahblah] TO DISK='D:\temp\configLogBackup.bak'
GO

BACKUP LOG [Sharepoint_Config_blahblahblah] WITH TRUNCATE_ONLY
USE [Sharepoint_Config_blahblahblah]
GO

DBCC SHRINKFILE (N'Sharepoint_Config_blahblahblah_log' , 50)
GO

Server 2008

net stop "System Event Notification Service"
net stop "Background Intelligent Transfer Service"
net stop "COM+ Event System"
net stop "Microsoft Software Shadow Copy Provider"
net stop "Volume Shadow Copy"
cd /d %windir%\system32
net stop vss
net stop swprv
regsvr32 /s ATL.DLL
regsvr32 /s comsvcs.DLL
regsvr32 /s credui.DLL
regsvr32 /s CRYPTNET.DLL
regsvr32 /s CRYPTUI.DLL
regsvr32 /s dhcpqec.DLL
regsvr32 /s dssenh.DLL
regsvr32 /s eapqec.DLL
regsvr32 /s esscli.DLL
regsvr32 /s FastProx.DLL
regsvr32 /s FirewallAPI.DLL
regsvr32 /s kmsvc.DLL
regsvr32 /s lsmproxy.DLL
regsvr32 /s MSCTF.DLL
regsvr32 /s msi.DLL
regsvr32 /s msxml3.DLL
regsvr32 /s ncprov.DLL
regsvr32 /s ole32.DLL
regsvr32 /s OLEACC.DLL
regsvr32 /s OLEAUT32.DLL
regsvr32 /s PROPSYS.DLL
regsvr32 /s QAgent.DLL
regsvr32 /s qagentrt.DLL
regsvr32 /s QUtil.DLL
regsvr32 /s raschap.DLL
regsvr32 /s RASQEC.DLL
regsvr32 /s rastls.DLL
regsvr32 /s repdrvfs.DLL
regsvr32 /s RPCRT4.DLL
regsvr32 /s rsaenh.DLL
regsvr32 /s SHELL32.DLL
regsvr32 /s shsvcs.DLL
regsvr32 /s /i swprv.DLL
regsvr32 /s tschannel.DLL
regsvr32 /s USERENV.DLL
regsvr32 /s vss_ps.DLL
regsvr32 /s wbemcons.DLL
regsvr32 /s wbemcore.DLL
regsvr32 /s wbemess.DLL
regsvr32 /s wbemsvc.DLL
regsvr32 /s WINHTTP.DLL
regsvr32 /s WINTRUST.DLL
regsvr32 /s wmiprvsd.DLL
regsvr32 /s wmisvc.DLL
regsvr32 /s wmiutils.DLL
regsvr32 /s wuaueng.DLL
sfc /SCANFILE=%windir%\system32\catsrv.DLL
sfc /SCANFILE=%windir%\system32\catsrvut.DLL
sfc /SCANFILE=%windir%\system32\CLBCatQ.DLL
net start "COM+ Event System"

Server 2003

cd /d %windir%\system32
Net stop vss
Net stop swprv
regsvr32 ole32.dll
regsvr32 oleaut32.dll
regsvr32 vss_ps.dll
vssvc /register
regsvr32 /i swprv.dll
regsvr32 /i eventcls.dll
regsvr32 es.dll
regsvr32 stdprov.dll
regsvr32 vssui.dll
regsvr32 msxml.dll
regsvr32 msxml3.dll
regsvr32 msxml4.dll

If you see the error message :-

The User has insufficient access right

When trying to delete, move or carry out other operations on a mailbox do the following :

AD Users and Computers
View, Show Advanced
Double click on user
Click Security
Click Advanced
Tick the box include inheritable permissions

If you forget the password for the management console and the resetpass.bat doesn’t work. Then try the following :-

Right click on command prompt
Run as Administrator
Then CD to the tools folder and type resetpass.

Should work now.

Not really a computer tip but a car related one.

The light inside my car stopped coming on when I unlocked the car / opened the doors.

To get it to work again you have to hold the light button for 3 seconds whilst having the ignition turned to on.

Handy tip.

Passcode is “parity” if ever needed