"Enter MS JET OLE DB Initialization Information" ERROR VB6

[Skate Bart]

Hi there.

I developed a program that creates Data Reports using this way : http://www.vbtutor.net/vb6/lesson40.html
But instead of using "Microsoft Jet 3.51 OLE DB Provider", I used "Microsoft Jet 4.0 OLE DB Provider" because when I used "Microsoft Jet 3.51 OLE DB Provider" it couldn't connect to the database when testing the connection. But when I used "Microsoft Jet 4.0 OLE DB Provider" it worked perfectly.
It worked fine until recently I tried to run the application and it gives this error :



I enter all the data the way it is shown in the picture above, and when I click OK I get this error :



Please help me....

[firoz.raj]

is your .mdb is password protected ? .and you have forget to select Provider string .it is very essential .because provider string is very importent .and without it cannot be work at any rate.

[DataMiser]

You haven't shown any code so there is not much there to even guess at

[Skate Bart]

is your .mdb is password protected ? .and you have forget to select Provider string .it is very essential .because because provider string it cannot be work at any rate.

no. my .mdb is not password-protected. and what should I use as the Provider String (I mean, what should I enter to that textbox?)

[Skate Bart]

You haven't shown any code so there is not much there to even guess at

I didn't use any code. I created the Data Reports using Data Environments and made all the settings and preferences from the Data Environment itself. (Refer to the first link given on original post)

[DataMiser]

Actually I have never used the data environment, I always write ADO code to do data access.

[firoz.raj]

I didn't use any code. I created the Data Reports using Data Environments and made all the settings and preferences from the Data Environment itself. (Refer to the first link given on original post)

if you are dong using wizard .there must be an option to fill connection string there .i am sure .

[Skate Bart]

never mind guys. my problem is solved. it was a error with the file location.
big thank u to DataMiser and firoz.

[djb0602]

I had this problem and I resolved it by following the path on the datasource, you have find the .mdb flat file and place it at the end of that path.
Leave the user name: Admin
Leave password :blank
Leave the provide string: blank
Leave the Open Mode: DB MODE READWRITE

Once you place the .mdb file close everything and relaunch the APP and the software should open normally.

Good luck hope this helps resolve the issue.

DJB

[Elroy]

djb0602, welcome to VBForums, but you're 14 years late in answering the question. Hopefully, they have it figured out by now.