Scenario
When user click on Button1(which is a submit button), 2 values will be pass into the database -name1.Text and nric1.Text.

The code doesn't haven any error but however, it doesn't add into the database. Strange.

File coding
Imports System.Data.OleDb

Partial Class UpdateEmployee
Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim name As String = name1.Text
Dim nric As String = nric1.Text

Dim myConnectionString As String
myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\Documents and Settings\Guohao Chen\Desktop\WebSite7\App_Data\WSDatabase.mdb"
Dim myConnection As New OleDbConnection(myConnectionString)
Dim myQuery As String = "insert into Employee(Empname,Empnric) values('" + name + "','" + nric + "')"
Dim myCommand As New OleDbCommand(myQuery)

'open the database
myCommand.Connection = myConnection
myConnection.Open()

'close connection
myCommand.Connection.Close()
End Sub
End Class

Did you debug???

One good place to place a breakpoint would be here:
Then view the value of the myQuery variable and see if the query makes sense.

I would note that you are *NOT* protecting yourself against SQL Injection (admittedly not a huge problem with OLE DB limitations) and you aren't allowing a name of (for example) O'Brien

You'd be better off using a parameterized command, but at a minimum you should do
Also, as a minor point, the proper string concatenation operator in VB is the ampersand (&). You can use + but you are at the whim (okay the rules) of VB as to whether it does arithmetic or concatenation.

But anyway, start by debugging.