Lotus Approach

[vbbuddy]

Hi,
In my system i dont have Access database and i have only Lotus suite which has Lotus Approach. I want to use Lotus database as a back end to VB. I have VB6.0 and also i dont know database programming in VB. Can u help me that how can i connect lotus database.
Thanks

[Jenda]

Well you could connect to Notes via the ODBC driver (not sure if it's installed already but I believe you can download it for free from Lotus if it is not. Sorry don't have Notes in current job.) But you probably don't want to do that.

Even though you may use Lotus Notes as a relational database (kind of), it's not recomended. It's not what the product was created for.

Maybe you'd better look into LotusScript and desing and implement your application within Notes ... you should actualy be able to create an application that can be used either from the Lotus Notes client or over the web easily.


For the Approach ... you may create your database in Approach and then access the files using the ODBC drivers (via ADODB), but I believe there'll be the same problem as with Access (unless something changed recently) ... it will not work reliably under a high load.

Anyway since we do not know what will be your application like we can't help much.

What you should do is to read on ADODB in the docs.

Jenda