DataGrid运行时显示执行阶段错误'9':阵列索引超出范围
在调试的时候正确执行.
制成EXE文件后在本机的任何目录下执行都是正确的,但是如果把EXE文件复制到电脑A,在电脑A上执行和在调试机器通过共享执行这个文件都会显示标题所描述的错误.
想问问这是为什么?
程序代码如下:
Private Sub Form_Load()
dim cn as adodb.connection
dim sel_rs as adodb.recordset
set cn = new adodb.connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0 ; data source = '" & App.Path & "\datum.mdb'"
Set sel_rs = New ADODB.Recordset
sel_rs.CursorLocation = adUseClient
SQL = ""select describing,ratio,Manufacture,Dielectric_Constant from T_Main where stuff = 'BA'"
sel_rs.Open Trim$(SQL), cnn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = sel_rs
With DataGrid1
.Columns(0).Caption = "材料編號"
.Columns(0).Width = 2800
.Columns(1).Caption = "比重"
.Columns(1).Width = 800
.Columns(2).Caption = "生產商"
.Columns(2).Width = 800
.Columns(3).Caption = "介電常數"
.Columns(3).Width = 800
End With
End sub