XP boot’s and starts loading and restarts

If this is a problem you got after suddenly switching of your pc, without properly shutting down. Then here is the solution. Even safe mode may be not working.

1. Insert your XP cd and boot from it.
2. After booting from the cd select Repair option to get the dos mode.
3. In the dos mode type ‘help’ to get the list of commands.
4. Try the ‘logon’ or ‘fixboot’ command, if it fails then there is a chance’s of problem being displayed there itself. For example it may display that there is a problem in logging in, Reason may be corrupted file system so use chkdsk command.
5. Here use chkdsk (Check Disk) command to repair any corrupted file system.
6. Now use fixboot command to fix any damaged boot sector.
7. Use any other command depending on your need.
8. Now again try to use ‘logon’ command, now you should be able to logon. This means your problem is solved.

VBS Extract MS word document links to separate file

Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set f = objFSO.OpenTextFile("c:\hyperlinks.txt", 2 , True) 'file name’s to which links to be written
Set objDoc = objWord.Documents.Open("c:\Exercises.doc") 'Word document from which links have to be separated
Set colHyperlinks = objDoc.Hyperlinks
For Each objHyperlink in colHyperlinks
f.WriteLine(objHyperlink.Address)
Next

Date in VB.NET verses MS Access 2007

• Use date picker control in vb.net and set the Format property of the control to the required date format.

• Now in MS Access 2007 open the tables design view and set the format property of the corresponding fields’ data type to match the data type of date picker control of vb.net application.

• Now perform SQL date operations like a normal query, with out any need for code to change the date format for Ms Access.

VB.NET and MS Access OLEDB

Dim source As String

Dim prov As String

Dim pass As String

prov = "Microsoft.Jet.OLEDB.4.0"

source = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.Location())

pass = "123"

Dim con As New OleDb.OleDbConnection("Provider=" + prov + ";Data Source=" + source + "\Perfect_Engineering.mdb;Jet OLEDB:Database Password=" + pass)

con.Open()

VB.NET and MS Access ODBC Connection

Dim con_string As String

con_string = "Driver={Microsoft Access Drive(*.mdb)};DBQ=C:\test.mdb;"

Dim con As New Odbc.OdbcConnection(con_string)

Try

      con.Open()

            MsgBox("Database is open")

      Catch ex As Exception

            MsgBox("Cannot open the database:" + ex.ToString)

End Try

Be aware of malware

Do you know that malwares ask permission to enter your system.

Yes, it’s a type of malwares, enters while you visit malicious web sites.

Some malicious web sites may give fake warning that your system is affected and it will ask you to click ok  to solve the problem. Be aware of such type of risks.

It will show you a window like windows firewall window or like any other system window.

Cannot create a new partition( error: not enough space) - Vista\Windows 7

Me to faced the same problem when I had uninstalled and deleted the XP's partition. I dual booted my pc with vista and xp.

Solution for this problem is simple,

Just download a free partition tool called "EASEUS Partition Master Home Edition" and use it to partition.You can even use the unpartitioned or Can extend the existing partitions size and many more.