项目VB6访问2007.accdb水晶报告11.50 [英] Project VB6 access 2007 .accdb crystal report 11.50

问题描述

我在VB6中开发了一个Accounts帐户项目。我的数据库是访问2007 .accdb，我创建了一个晶体报告11.50



但是我运行程序时会要求数据库选择

和数据库密码也是



i已经通过密码打开记录集



所有数据输入都在进行complate





rsBill.CursorLocation = adUseClient

CnnAcc.openProvider = Microsoft.ACE.OLEDB.12.0; Data Source =DBPath\db.accdb; JET OLEDB：Database Password =& DbPwd& ;

rsBill.OpenBILL，cnnAcc，adOpenDynamic，adLockPessimistic，adCmdTableDirect



我的尝试：



i想要报告我的VB6项目数据库访问2007.accdb



怎么样才能我完成了会计项目报告

i have devloping a project for Accounts in VB6. My database is access 2007 .accdb, i had creat a crystall report 11.50

but whne i run the program there are ask for databse salection
and database password also

i had allready open recordset by password

all data entry doing complate


rsBill.CursorLocation = adUseClient
CnnAcc.open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="DBPath\db.accdb";JET OLEDB:Database Password=" & DbPwd & ";"
rsBill.Open "BILL", cnnAcc, adOpenDynamic, adLockPessimistic, adCmdTableDirect

What I have tried:

i want to craet report for my VB6 Project database acess 2007 .accdb

how can i done my Report for Accounting Project

推荐答案

这可能是您的密码... Access中有奇怪的行为！

此链接更多信息和一些解决问题的建议

访问连接字符串 - ConnectionStrings.com [< a href =https://www.connectionstrings.com/access/\"target =_ blanktitle =新窗口> ^ ]

It may be your password...there are strange behaviours in Access!
This link has more information and some suggestions to get around the problems
Access connection strings - ConnectionStrings.com[^]

这篇关于项目VB6访问2007.accdb水晶报告11.50的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！