MSDN FILES FOR ACCESS DB

[hubud]

I HAVE BEEN TRYING TO LINK FROM VB6 TO AN ACCESS DB AND WHEN I ENTER THE RECORDSOURCE AS THE DB I WANT IT STATES THAT THIS SOURCE IS NOT RECOGNISED. HELP STATES THAT THE MSDN NEEDS TO BE REINSTALLED.
I HAVE RUN THE .EXE FOR CD 1 HOWEVER THE PROBLEM STILLS PERSISTS.
ANY IDEAS? BEING NEW TO THIS I AM WONDERING IF I NEED TO INSTALL TO A PARTICULAR DRIVE OR LOCATION. THE VB IS LOCATED ON F DRIVE AND IS CALLED FROM THE C PARTITION.

 

[lesina]

Hello,

let me try to help you on what i can.
So, you want to open a database(access one ) from your VB6 project.
Ok, just do it like this:
When you load the form you must define the database you're using:
Data1.DatabaseName = App.Path & "\abc.mdb"(for example)
Data1.RecordSource = "select * from table_i_want"
Then just use when you want:

With Data1
.Recordset.MoveFirst
'first register

Do Until .Recordset.EOF
If (.Recordset.Fields("Field_i_need&quot = Text1.Text) And (.Recordset.Fields("Another_field_i_need&quot = Text2.Text) Then
'all correct
Unload Me
Form2.Show
Exit Sub
Else
.Recordset.MoveNext
End If
Loop
...

Hope this helps
Good luck
===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
IndraCPC
-------------------
Portugal
===================