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. 

cd/dvd drive slowing down the pc

playing a video is not smooth or pc slows down when copying from the dvd drive. But the dvd drive was working normally.
It may be because of slight modification of settings. To solve this
* go to device manager.
* Under IDE ATA/ATAPI contrllers, check under the advanced settings tab of properties window for all the sub optioins.
* Set transfer mode as DMA for all of them.
* Now restart and check.
* If this doesn't work, just uninstall the dvd driver and select add hardware to reinstall the driver again, this may solve.
* If both of this fails, open your cabinet and plug the dvd drives bus in another socket.

Disabling visual studio just-in-time debugger

It may be irritating to see the just in time debugger popping up continuously