Run time error '91'

[Mfanelo]

Hey there

I am currently experiencing a run time error with my project and seeking advise on what to do in this regard. The run time error is:

Run-time error "91"
object variable or With Block variable not set

If anyone can assist I would highly appreciate it. I am trying to run my application from a remote PC.

[Pasvorto]

Show us the code where it is happening. You are referencing an object that has not been set yet.

[Shuja Ali]

As posted show us the code.

Usually this error happens when you are trying to using an uninitialized object. Something like this

Dim accessCon As ADODB.COnnection
'this line will throw an error
AccessCon.ConnectionString = "......"

[Mfanelo]

The thing is when I play the application where the development is being done the error does not show but when I make it to be an .exe and try to play it after downloading it, it gives me the error.

Remember I am trying to access it from remote/other workstations. Any ideas????? please..........

[Shuja Ali]

You must atleast have an Idea which function is throwing this error. Try to check what that function does and see if you can pinpoint the error.

The problem here is that we cannot help unless we see the code or exact description of the problem.

[King_George]

You have to SET the object too.

Dim accessCon As ADODB.COnnection
SET accessCon = New ADODB.COnnection

or

Dim accessCon As New ADODB.COnnection <- not recommended because of memory leaking problems.


AccessCon.ConnectionString = "......"

Edited to correct a stupid quoting mistake...

[Shuja Ali]

You have to SET the object too.

Dim accessCon As ADODB.COnnection
SET accessCon = New ADODB.COnnection

or

Dim accessCon As New ADODB.COnnection <- not recommended because of memory leaking problems.


AccessCon.ConnectionString = "......"

What was that for?

[Al42]

Are you just copying the .exe file to the other computer, or are you copying the installation package and installing the whole application?

[King_George]

What was that for?

OOPS... I'll edit that...sorry

[Pradeep1210]

You have to SET the object too.

Dim accessCon As ADODB.COnnection
SET accessCon = New ADODB.COnnection

or

Dim accessCon As New ADODB.COnnection <- not recommended because of memory leaking problems.


AccessCon.ConnectionString = "......"

Edited to correct a stupid quoting mistake...

King, actually I suspected the same.
But shouldn't it give error in IDE too

Pradeep

[King_George]

King, actually I suspected the same.
But shouldn't it give error in IDE too

Pradeep

Not always. You probably do not have Option Explicit turned on. As a note, ALWAYS have this at the top of each form module and you'll never get this type of error.

Remember the IDE is different that a runtime environment.

[Mfanelo]

To answer AL42, I am downloading the application from a server into another workstation that doesn't have VB6....

[randem]

You still need to install the application for it to work correctly.

[Al42]

What randem said - you can't just copy files with a program written in VB.

[Mfanelo]

I seem to have figured what the problem is, its the ADODC connection that I'm using cause with the ADODB connection method the application seems to work. Now my question is, is there a way of solving this or will I have to use the adodb connection outrite. If so can some one let me know of how I can connect a datagrid using the ADODB method.

Thanks in advance..............