Help with Password protected Access DataFile
keturpatel
India
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.
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.
Comments
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.