Handling MSAccess UserId and Password

[RobertRob]

I have much trouble with this problem:
an msaccess 97 database, secured with a mdw file, is correctly accessed by vb. When I try to access by Crystal report (7 or 8 makes no differencies) it return me a message like "there are no sufficient permissions in reading data"...
I've set the SetSessionInfo parameters, etc, but the results are the same.
The problem seems to be linked to the cohesistance of more than 1 .mdw files
Could anyone help in this trouble?

 

[kvinod2]

dear all,
i want to know how to connect to msaccess 97 to oledb
datasource ?

what should be the datasource, location and userid , password

i am using crystal report 7


waiting for reply
k_vinod2