Database

[Drew]

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?

[James Longstreet]

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

[Drew]

It does not make a difference ADO or DAO.

[James Longstreet]

'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