سلام
من به یه مشکل رسیدم برای 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."
در صورت امکان راهنمایی کنید
ممنون