you could try this.

Dim strSQL2 As String
     strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'"
     Dim comDA as new oledb.oledbdataAdapter
     comDAdeletecommand = new oledb.oledbdataAdapter(strSQL2, conpayroll)
     comDA.deletecommand.ExecuteNonQuery()
     MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)

Sounds like windows server 2003 doesn't contain a native driver for the hard disk controller (common enough with newer hardware and older software).
Go with server 2008 if possible or use the F6 to specify a third party driver during startup (when dell drivers site is functioning correctly again).

Thanks John, I don't have the dataset.xsd in solution explorer, only Proj_Name with sub entried My Project and form1.vb
Also I am using visual studio 2008 express edition so some features are not available though. The other problem is while
I can click and get this information, I need the code / program to do it. Seems to be a tricky one alright.

Probably not related to the cast error but you are missing the line "comEMT.commandtext = strSQL2" in the last section

I added it in here

 Dim strSQL2 As String
                                strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'"
                                comEMT.commandtext = strSQL2
                                comEMT.ExecuteNonQuery()
                                MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)[/b]

Thanks for the reply, I think I may have worded that incorrectly. I can get the column data alright but its the design of the tables I need. I want to see which columns in the tables are primary keys, data type, allow duplicates / nulls etc.