Click here to Skip to main content
15,895,777 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted
Updated 18-Nov-17 0:53am

1 solution

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[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900