سلام
من به یه مشکل رسیدم برای connection در vb به فاکس پرو اگر از کد زیر استفاده کنم :

Dim Conn As New ADODB.Connection
()Private Sub Form_Load
aaa = 33
"a = "tbl
Set DBConn = Nothing
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\test;Extended
";Properties=dBASE III
Set DBConn = Conn
"( '"& SQL = " INSERT INTO " & a & " Values ( '" & aaa
DBConn.Execute SQL
End Sub

این error را دارم :

"Selected collating sequence not supported by the operating system"

و

"External table is not in the expected format"

واگر این کد :

Dim Conn As New ADODB.Connection
()Private Sub Form_Load
aaa = 33
"a = "tbl
Set DBConn = Nothing
;Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\test
Set DBConn = Conn
"( '"& SQL = " INSERT INTO " & a & " Values ( '" & aaa
DBConn.Execute SQL
End Sub

این error :

"The Microsoft Jet database engine cannot open the file 'E:\test'. It is already opened exclusively by another
user , or you need permission to view its data."

در صورت امکان راهنمایی کنید
ممنون