Kirk,

I might have found something that (at least) explains what's going on in both our problems (and maybe helps to fix them):

http://www.codeproject.com/dotnet/UB_CAS_NET.asp?target=Code+Access+Security

I havn't tried any of its solutions just yet but will today.

Richard





>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
>