Failed to connect with OLE DB(ADO) to a Cripted Access 2007 Data base

[Former Member]

Developper enviroment:

- Crystal Report XI

- Visual Basic 6.3

- Access 2007

I try to use one Access 2007 DB CRIPTED with OLE DB(ADO) in the Development Enviroment using the Password utilized to cripted the DB and I have this error messagge:

- Access

- ADO Error Code : 0x80040e4D

- the information file is missing or open in exclusive mode

I Try also to insert the user name: Admin ( that is not inluded in the cripted Access DB ) but with the same error.

The access to a ACCESS 2007 DB Not Cripted work well, the problem is how to access a Cripted Access DB.

Can You help me.

Regards

Giovanni Roi

[Former Member]

Dear Collegue,

I solve this case.

Whit ACCESS 2007 CRIPTED DB in the OLD DB(ADO) Panel of CR we have to insert ONLY the PASSWORD in PASSORD DATABASE JET without insert any other information (User name e user password).

Regards

Giovanni Roi

[Former Member]

Have you tried verfiying the database through CR and closing and opening it again? Perhaps it is to do with Login issues over ADO?

Perhaps showing your code can shed some light?

It could be the login issue but need to check.

Here is another link which had similar problem

[LINK|http://www.programmersheaven.com/mb/VBasic/316909/316909/crystal-report-9-and-password-protected-access-database/?S=B20000]

Regards

Jehanzeb

[Former Member]

Thank's Jehanzeb, Your information solve the problem to view the Reports from Runtime.

Regards

Giovanni Roi