I have VB6 and I have made a data base in Lotus Approach. Can I implement the data base into my VB progaram. If so, then is there something I have to set in the components or is there something else I have to set?
Printable View
I have VB6 and I have made a data base in Lotus Approach. Can I implement the data base into my VB progaram. If so, then is there something I have to set in the components or is there something else I have to set?
Not familiar with LOTUS but if you can use an ODBC driver with LOTUS then you can use it in VB. You have to configure a ODBC dsn and use that as the access to your database.
If you can be more specific as to what you are using the database with ( ADO, DAO, etc...) you can probably get an example of how to use it.
Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com
It does not make a difference ADO or DAO.
'ado example
Dim conn as ADODB.Connection
Dim rs as ADODB.Connection
set conn = new ADODB.Connection
conn.Open "DSN=YOURDSNNAME"
rs.Open "SomeTable", conn, adOpenDynamic, adLockOptimistic, adCmdTable
that will open a databbase and a recordset. For more detail I would suggest reading the online help for ADO, as it is complicated.
Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com