我用VB写了一个程序,用GP-Install软件做了个安装程序,在机子上安装后再
卸载,发现该安装程序把系统自带的控件和动态链接库都给卸了,事实上我在卸载
时也选择了保留共享组件,搞得我再次用VB打开程序时许多控件都加载不了了。
不知道哪位能够给我提供一个解决方案。谢谢!
卸载,发现该安装程序把系统自带的控件和动态链接库都给卸了,事实上我在卸载
时也选择了保留共享组件,搞得我再次用VB打开程序时许多控件都加载不了了。
不知道哪位能够给我提供一个解决方案。谢谢!
Public Sub CreateDB()
Dim cat As New ADOX.Catalog
Dim strCn As String
Dim strSQL As String
On Error Resume Next
If Dir(App.Path & "\DB\temp.mdb") <> "" Then
Kill App.Path & "\DB\temp.mdb"
End If
strCn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\DB\temp.mdb" cat.Create strCn Set g_TempCn = New ADODB.Connection
g_TempCn.Open strCn strSQL = "CREATE TABLE fc_prod (" & _
"hs_code smallint NOT NULL ," & _
"m_num smallint NOT NULL ," & _
"c_flod int NOT NULL ," & _
"CONSTRAINT 旬资料配置 PRIMARY KEY(hs_code,m_num))"
g_TempCn.Execute strSQL
strSQL = "CREATE TABLE interbasin_prod (" & _
"hs_code smallint NOT NULL ," & _
"m_num smallint NOT NULL ," & _
"c_flod int NOT NULL ," & _
"CONSTRAINT 旬资料配置 PRIMARY KEY(hs_code,m_num))"
g_TempCn.Execute strSQL
strSQL = "CREATE TABLE outflow_prod (" & _
"hs_code smallint NOT NULL ," & _
"m_num smallint NOT NULL ," & _
"c_flod int NOT NULL ," & _
"CONSTRAINT 旬资料配置 PRIMARY KEY(hs_code,m_num))"
g_TempCn.Execute strSQL
Set cat = Nothing
End Sub其中一句cat.Create strCn执行了。可是它就是不生成临时数据库文件temp.mdb.
Dim tbl As New ADOX.Tablecat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"没有啥问题
看看路径有没有问题
换一个吧。
可能是GP-install的bug.