Help with Password protected Access DataFile

keturpatel

Dear all,

We have been using Crystal reports since 8 years and now looking for any good alternative. Currently i have downloaded demo of Fast Report Studio and trying to create some reports from it.


When i try to connect fast report with my password protected access mdb file, it gives me following error -

"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user"

I have verified that no other user is using file. also checked that system.mdw file is present in my system directory.

Can anyone tell me how to connect to this database ? Your help is very much appreciated.

Also i would like to see some more VB6 code examples.

Thanks in advance.

OlegK

Check the connection string. Perhaps you made error in Data Source, User ID or Password.

keturpatel

Dear OlegK,

Thanks for reply.

I have tried it several times with no success.

I'm sending you a screen shot. just guide me where i'm wrong.

I'm using Microsoft Jet 4.0 OLE DB Provider.

When i'm using same report with my connection string to database, it works.
this problem comes only when i try to build connection from design view.

OlegK

Try user-level security wizard in access and DO NOT rename workgroup file, just leave it as Security.mdw.