i need help, error: "user defined type not defined"

[ana10192000]

VB6.0

Private dbParts as Database
Private dbParts as Recordset

guys help, i can't execute my program
compiler error says: " user-defined type not defined "

i'm not much a knowledgable programmer, i'm still just a student, do explain it in a little bit detailed statements.
thanks!

[danp129]

Try adding a reference to Microsoft ActiveX Data Objects 2.x Library

[jasjas]

are u connecting your VB to Database? if yes mayb is the name of your coding are not mach to your database field name.....*mayb only.

[Killer42]

are u connecting your VB to Database? if yes mayb is the name of your coding are not mach to your database field name.....*mayb only.

That would be picked up at runtime, not by the compiler.

[jasjas]

oic..so that i only say "mayb only".

[ana10192000]

Try adding a reference to Microsoft ActiveX Data Objects 2.x Library

hi i already did this, but it only says "permission denied"
what do you think is the prob?
some of my classmates are also experiencing this. Our instructor is not helping us...

pls help...

[danp129]

hi i already did this, but it only says "permission denied"
what do you think is the prob?
some of my classmates are also experiencing this. Our instructor is not helping us...

pls help...

So do you get Access denied if you start a blank project and try to add a reference to Microsoft ActiveX Data Objects 2.x Library and just click ok?

[SkinHead]

Hey ana10192000....

Private dbParts as Database
Private dbParts as Recordset

Firstly, You Can't Have Two Variables With The Same Name !
Also, I Think The "user-defined type not defined" Error Is To Do With The Database Type. There Isn't One.

If You've Managed To Add A Reference To The Microsoft ActiveX Data Objects 2.x Library, Then Try :

Private conParts as ADODB.Connectio n
Private rsParts as ADODB.Recordset

[danp129]

haha I hadn't noticed the same names. Shouldn't have to specify ADODB unless some other reference has a 'connection' or 'recordset' class.

[Killer42]

If they're still teaching ten year old VB6, maybe they expect the students to use DAO.

[ana10192000]

Hey ana10192000....

Private dbParts as Database
Private dbParts as Recordset

Firstly, You Can't Have Two Variables With The Same Name !
Also, I Think The "user-defined type not defined" Error Is To Do With The Database Type. There Isn't One.

If You've Managed To Add A Reference To The Microsoft ActiveX Data Objects 2.x Library, Then Try :

Private conParts as ADODB.Connectio n
Private rsParts as ADODB.Recordset

sorry it's not

Private dbParts as Database
Private dbParts as Recordset

it must be

Private dbParts as Database
Private rsParts as Recordset

pardon me

[ana10192000]

If they're still teaching ten year old VB6, maybe they expect the students to use DAO.

we're actually using DAO...

[ana10192000]

guys is there any possibility that the VB6 installed on my PC has some missing components that's why it is saying "permission denied"?

[danp129]

guys is there any possibility that the VB6 installed on my PC has some missing components that's why it is saying "permission denied"?

Is it your computer or school computer?

[ana10192000]

Is it your computer or school computer?

school computer..

the best that i think i can do now is to do my program all over again outside the school... it's nonsense to ask help for those who doesn't want to help...
i'm so sad this time but i have no choice...

guys thanks