Runtime error 91

[opie]

I created this program on Vista using VB 6.0 with Access as the DB. When I created the executable and was trying to use it, on a XP machine, it gave me two issues. The first problem was it was missing the MSADODC.OCX file which I got and I also downloaded VBRun60sp6.exe.

Now I am getting Runtime error 91 and cannot figure out why any ideas?

[opie]

I figured out part of the problem. It seems to only happen on pages that I used an ADODC. I also installed VB 6.0 that I used to create the program and it seem to fix the problem, but I can't install 6.0 on every computer that this program will work on. Any Ideas on a fix?

[lotus18]

I figured out part of the problem. It seems to only happen on pages that I used an ADODC. I also installed VB 6.0 that I used to create the program and it seem to fix the problem, but I can't install 6.0 on every computer that this program will work on. Any Ideas on a fix?

Installing a vb6.0 on a client's computer is not really a good practice. Have you tried the Package and Deployment Wizard?

Rey Sean

[krafla]

I have a similar problem with a program i made with VB 6.0 - the only control I used is MSFlexGrid - the program was developed on an XP machine. and the first time to use it on another machine i got two errors:

1-
Class Not Registered
Looking for Object with CLSID:{0000010-0000-0010-8000-00AA006D2EA4}

this error message appears only at start up and as i click OK the program starts without reading the DB file. and if i save a new entry (create a new row in the DB) it gives me the second error:

2-
Run-time error '91':
Object Variable or With Block variable not set.

Note: I'm using an Access 97 DB associated with the program.
The computer on which i am testing the program has Access 2007. can this be a clue?

I don't know what is missing is in the VB 6.0 or in the Access 97.

a final question, what is the "Package and Deployment Wizard" ??

[lotus18]

I have a similar problem with a program i made with VB 6.0 - the only control I used is MSFlexGrid - the program was developed on an XP machine. and the first time to use it on another machine i got two errors:

1-
Class Not Registered
Looking for Object with CLSID:{0000010-0000-0010-8000-00AA006D2EA4}

this error message appears only at start up and as i click OK the program starts without reading the DB file. and if i save a new entry (create a new row in the DB) it gives me the second error:

2-
Run-time error '91':
Object Variable or With Block variable not set.

Note: I'm using an Access 97 DB associated with the program.
The computer on which i am testing the program has Access 2007. can this be a clue?

I don't know what is missing is in the VB 6.0 or in the Access 97.

a final question, what is the "Package and Deployment Wizard" ??

I really have no idea about the two errors because i didn't encountered these. Just standby, other experts here will give you a solution. For Package and Deployment Wizard
is a built-in in vb6 (in visual studio rather) in which you can create setup file (installer) for your program : )

Rey Sean

[krafla]

Thanx so much Lotus18 i have tried the PDW but it did not work as well, same errors, what i learned is that it is something that has to do with the Access Database Engine - i should include the one associated with the access 97 and let the PDW copy it on the host PC. the only problem now is that, i dunno what it is called (the DLL of the Access Database Engine).

Thank you so much anyway.

as for illasabba, thank you for being not helpful at all, i've read the database part in the tutorial and nothing about MSFlexGrid control so please try to be more specific next time, i will not read a book or 23 chapters each time i wanna debug an error for i have no intention to spend my life reading. try to practice more than read

[creative1]

You can create a setup using Project and Deployment Wizard if you have any compilar error in your program. So you need to fix your error first.
Kind Regards

[lotus18]

Thanx so much Lotus18 i have tried the PDW but it did not work as well, same errors, what i learned is that it is something that has to do with the Access Database Engine - i should include the one associated with the access 97 and let the PDW copy it on the host PC. the only problem now is that, i dunno what it is called (the DLL of the Access Database Engine).

Thank you so much anyway.

as for illasabba, thank you for being not helpful at all, i've read the database part in the tutorial and nothing about MSFlexGrid control so please try to be more specific next time, i will not read a book or 23 chapters each time i wanna debug an error for i have no intention to spend my life reading. try to practice more than read

Actually I'm not using the Package and Deployment Wizard for quite some time. I used other setup utility tools like the Inno setup, or the installshield setup. I also encountered similar problem like this. I think the problem is not the dll but the path of the database. Have you checked the path? (This is just a guess)

Rey Sean