Sub Main()
AddRecord()
End Sub
Sub AddRecord()
Dim strConnectionString As String = "Provider=VFPOLEDB.1;Data Source=clients.dbc;password='';user id=''"
Dim objConn As New OleDbConnection(strConnectionString)
objConn.Open()
Dim strSQL As String = "Insert into accounts (mscacct) VALUES ('MSCTEST')"
Dim objCmd As New OleDbCommand(strSQL, objConn)
Try
objCmd.ExecuteNonQuery()
Catch e As Exception
Console.WriteLine(e.Message)
End Try
Console.WriteLine("Record Added")
End Sub
I' getting an error when executing the exe in line AddRecord() in Sub Main().
An unhandled exception of type 'System.Security.SecurityException' occurred in ADOtoDBF.exe
Additional information: Request failed.