Monday, May 12, 2008

Time sync between server and client

Time Sync between server and workstation following commands
are used

w32tm /config /update
w32tm /resync

Start and Stop using time service using

net stop w32time && net start w32time

Tme server in Windows Server 2003

Time service to use an internal hardware clock

To configure the PDC master without using an external time source, change the announce flag on the PDC master. The PDC master is the server that holds the forest root PDC master role for the domain. This configuration forces the PDC master to announce itself as a reliable time source and uses the built-in complementary metal oxide semiconductor (CMOS) clock. To configure the PDC master by using an internal hardware clock, follow these steps:1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey:
3. In the right pane, right-click AnnounceFlags, and then click Modify.
4. In Edit DWORD Value, type A in the Value data box, and then click OK.
5. Quit Registry Editor.
6. At the command prompt, type the following command to restart the Windows Time service, and then press ENTER:
net stop w32time && net start w32time

Wednesday, May 7, 2008

Find duplicate entries in excel

Go to excel -->tools -->macro - visual basic editor then paste the below code and run..

Sub FindDups ()
' NOTE: You must select the first cell in the column and
' make sure that the column is sorted before running this macro
ScreenUpdating = False
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1, 0).Value
Offsetcount = 1
Do While ActiveCell <> ""
If FirstItem = SecondItem Then
ActiveCell.Offset(Offsetcount,0).Interior.Color = RGB(255,0,0)
Offsetcount = Offsetcount + 1
SecondItem = ActiveCell.Offset(Offsetcount, 0).Value
ActiveCell.Offset(Offsetcount, 0).Select
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1,0).Value
Offsetcount = 1
End If
ScreenUpdating = True
End Sub

Saturday, May 3, 2008

error number: 0x800c0133” Outlook Express

When you try to send or receive messages using Outlook Express, you may receive error message as below.

"An unknown error has occurred. Account: 'Example', Server: '', Protocol: POP3, Port: 110, Secure (SSL): No, Error Number: 0x800C0133 "


All the mail disappear
Unable to download emails
E-mail message could not be sent.

This behavior can occur if the Folders.dbx file is missing, damaged, or using the read-only attribute. Usually it will happen at inbox.dbx.

To remedy

Try to restart the computer, if the problem persists, please follow the following steps.


the Inbox.dbx file:

Go to “Tools” > “Options” > “Maintenance” tab > Click “Store Folder”. It will reveal the location of your Outlook Express files.
Close Outlook Express, goto the location mentioned above. You may copy the location and paste it in the “Start” > “Run” and click “Ok”.
Rename “inbox.dbx” to “oldinbox.dbx” or name that you prefer.
Restart the Outlook Express, This creates a new inbox.dbx file automatically.

Recovery old emails

You may recover back the old emails by try the following, if they are not corrupt or damage.

In Outlook Express, right click on the local folders icon in the folder list.
Click on New Folder, named it to “Old Inbox”.
Search for oldinbox.dbx.
The old emails should be inside the oldinbox.dbx right now.