我打包后,安装在别人电脑上,出现数据库路径出错,可我用的是相对路径。这是怎么回事?是不是我VB安装的有问题?
程序代码如下:
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\信息.mdb;Persist Security Info=False"
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Frm_AddClass.Adodc1.Refresh
Frm_AddClass.DataGrid1.Refresh
Set DataGrid1.DataSource = Adodc1
End Sub代码访问也有同样的问题:
myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\信息.mdb;"
myRs.Open "select * from 用户资料 where 用户名='" & strName & "'", myConIf Not myRs.EOF Then
Text1.SetFocus
MsgBox "该用户名已经存在,请使用其他用户名!", vbOKOnly, "警告"
myRs.Close
myCon.Close
Exit Sub
End IfIf strPass <> strPassAgain Then
MsgBox "两次输入的密码不同!", vbOKOnly, "警告"
Text3.SetFocus
myRs.Close
myCon.Close
Exit Sub
End If
myRs.Close
希望各位多多帮忙!急!!!
程序代码如下:
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\信息.mdb;Persist Security Info=False"
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Frm_AddClass.Adodc1.Refresh
Frm_AddClass.DataGrid1.Refresh
Set DataGrid1.DataSource = Adodc1
End Sub代码访问也有同样的问题:
myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\信息.mdb;"
myRs.Open "select * from 用户资料 where 用户名='" & strName & "'", myConIf Not myRs.EOF Then
Text1.SetFocus
MsgBox "该用户名已经存在,请使用其他用户名!", vbOKOnly, "警告"
myRs.Close
myCon.Close
Exit Sub
End IfIf strPass <> strPassAgain Then
MsgBox "两次输入的密码不同!", vbOKOnly, "警告"
Text3.SetFocus
myRs.Close
myCon.Close
Exit Sub
End If
myRs.Close
希望各位多多帮忙!急!!!
解决方案 »
- 程序未退出时,生成的文本数据不更新
- VB中的小问题
- 这样叫什么?给变量的变量名赋值?
- Picture1显示串位
- 脑子要炸了.vb高手快帮帮忙把,怎么讲0x11,0x15,0x22,0xf9,.....转化成111522f9......发送,来帮我讨论下把
- IIS迷你版+SQL精简版+DreamWeare精简版=50M,三分钟建立ASP+SQL开发环境。
- vb,msde程序如何发布
- ***********如何返回一個打印机中某一紙張格式的id值???急********************
- 关于字串的提取!
- Excel VBA处理数据功能怎么样
- 求助 vb
- ADO访问EXCEL用什么引擎能够在SQL查询语句里使用CASE WHEN语句?
app.path要注意这一点
Public gsOdbcName As String
Public ADOsdb As new ADODB.Connection gsOdbcName = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= " _
& app.path & "\db.mdb " & "; "
With ADOsdb
If .State <> adStateOpen Then
.CursorLocation = adUseClient
.ConnectionString = gsOdbcName
.Open
End If
End With