Richard (and everyone else)
two things.
1. I rewrote the code without the vfptoolkit, that did not solve the problem, still have the same thing, but the toolkit is now one less layer.
2. (A) It still runs perfect on my development machine, with the datbase located another machine.
(B) I had be attempting to run the application with it stored on a file server and still receive the same error.
(C) When I copied the application directory to the individual workstation, it ran fine.
That doesn't make too much since to me, I changed the rights on the directory where it's stored to everyone full, and the same error.
Public Shared Function GetDataView(ByVal tcSQLCMD As String) As DataView
Dim cnn As New SqlClient.SqlConnection
Dim cmd As New SqlClient.SqlCommand
Dim da As New SqlClient.SqlDataAdapter
Dim ds As New DataSet
cnn.ConnectionString = AppGlobals.AppConnString
Try
cnn.Open()
Catch ex As SqlClient.SqlException
MsgBox("Can't Open" & vbCr & ex.Message, MsgBoxStyle.Critical, "Title")
End Try
cmd = cnn.CreateCommand
cmd.CommandText = tcSQLCMD
da.SelectCommand = cmd
da.Fill(ds)
Dim dv As New DataView(ds.Tables(0))
cnn.Close()
Return (dv)
End Function