Generating Crystal Report's in VS2005 Using ACCESS database

[sameerpandurangi]

Hello Everybody,

Am using ACCESS database in my project and want to generate crystal reports. It's working fine on my machine but when i deploy and create set up file nad run it on some other machine.Crystal report is acking for user name and password(I have not used user name and password for my ACCESS database).The other coding part is working fine except crystal report.
Any one who can Help me.
Please

 

[giadich]

check the connection/permission that you are using.

Are you using DSN? Do you have one setup on the client machine?

 

[sameerpandurangi]

Thanks for the reply,

dim db As New ADODB.Connection
dim strsql as string

strsql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=main_address_book.mdb"
db.Open(strsql)

This is the connection string that i am using.
and i have not set user name and password for my database.
I am not using any DSN connection.Is it necessary????
It's working fine on my machine without DSN,But the problen is reports are not working on client machine.