What code would you use to open a MSAccess file in VB 6?

Question

*.mdb file

Answer 1

Dim MyCon As New ADODB.Connection
Dim MyRs As New ADODB.Recordset
Private Sub Form_Load()
MyCon.Open "Provider=Microsoft.jet.oledb.4.0; Data source=c:\R.mdb"
'R is the mdb file
MyRs.Open "select * from emp", MyCon, adOpenDynamic, adLockOptimistic
'emp is the table
End Sub


Further add the reference
Microsoft ActiveX Data Objects2.0 Library

Answer 2

i anticipate acdsee is a everyday photo viewing software, so how do you open a tiff record.... uh... "open".... what do you pick to do with the tiff record? Tiff is a conglomeration of many sub-formats... you're beginning a huge can of worms.

Answer 3

Use the referenz to ADO, in this way you can build most of the things you like.

Helmut

Answer 4

component