Visual Basic 6 - Novice question?

[xtraboot]

Ok ive been programming on VB for years, but with work commitments ive not sat down and done any for about 3-4 yrs my self.

Now I did a course back in 2003 which showed you how to connect a MS Access Database file MDB to ADODC component (ADODC1 default name)

Ive selected:
Use Connection String
Build Button
Selected my DB file
Test Connection Button

All if ok and sucessful
Pressed ok gone to record source
selected 2 - AdCMDtable

and Userdetails appears (A table in that database file)

But every time I run any command like (Example)
A$ = Logindb.Recordset.Fields(1).Value

A$ = Logindb.Recordset.RecordCount

I get a error
Run Time Error 91
Object Variable or With block veriable not set

Can any one help out
or is it because ive not set X as Recordset etc at the header of the scripting
Sorry just to add the connection provider selected was...

Microsoft Jet 4.0 OLE DB Provider
Anna:-
I appreciate your attempt to help me but you have given me a .net link (VB.net) and thequestion is specifically around VB6
RESOLUTION WAS FOUND!:

Want any of the replies given
It turned out I failed to link the components to the ADODC

Example: Text Box to read from ADODC1, Field...

Therefore made the ADODC1 component innactive.

All resolved now

[Anna C]

Sorry, VB does my head in. This may refresh your memory though?

http://www.homeandlearn.co.uk/NET/vbNet.html

[Amit]

it is exactly what is wromg.
more over if u can try the following code too.
follow the steps
Use Connection String
Build Button
Selected my DB file
Test Connection Button

All if ok and sucessful
Pressed ok gone to record source
selected 2 - AdCMDtable

and Userdetails appears (A table in that database file)
then
do this .
'************************************************* *********************
Public conn As Connection
Public rsparty As Recordset
Public rsmeterial As Recordset
Public str, constr
************************************************** ********************
'************************************************* *********************
Public Function con()
str = App.Path & "\"
Set conn = New Connection
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str & "mydb.mdb;Persist Security Info=False"
conn.Open constr
Set con = conn
End Function
************************************************** ********************
htis is how u can connect db after inatalling ur package in any drive.
hope this will solve ur problem.