Crystal report login to a database password protected MS Access File

  • Thread starter Reny J Joseph Thuthikattu
  • Start date
R

Reny J Joseph Thuthikattu

Hi,
I have created a DataBase Password Protected MS Access DB ,instead of
creating a new password for Admin Login.
Now i am abale to connect to DB from VB.NET with connection string
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program
Files\communication\pbx.mdb;Jet OLEDB:Database Password=xyz

Now the problem shifted to Crystal Report.At design time of the report i can
able to log in with following info.

Database Name: C:\Program Files\communication\pbx.mdb

Database Type: Access

UserID: Admin

Password:

Jest System DataBase:

Jet Database Password: xyz

From there i can able to design the report.But when i try to run again am
getting following dialog box asking for following information

Table Name: Records

Server Name : C:\Program Files\communication\pbx.mdb

Database : Access

Login ID:Admin

Pasword:

(Where do i specify the Jet System Database Password?)If i say finish , i am
getting Login Failed.



Help Me Out

Reny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crystal Report and password protected Access database 1
OleDb Connection String For MS Access 2007 Clarification. 1
How to pass database login screen 3
How to Open a Password encrypted .accdb 0
Password problem 2
problem while connecting to a secured MS Assess DB 2
ADO wants exclusive access to MSAccess 7
Workgroup file information file error: OleDB to Access file 3

Top