>>>>>Which report tool is best to be used in VB6 and Access 2000
>>>>>database? Thanks.
>>>>
>>>>I prefer Active Reports (www.datadynamics.com). More code to write but a lot more flexibility!
>>>>
>>>>Access reports are not to bad too.
>>>>
>>>>One thing for sure, forget the DataReport that comes with VB6!
>>>
>>>If I were to use Access 2000 reporting feature, how can I call from
>>>my VB6 application? Some sample example would be appreciated. Thanks.
>>
>>Notice that you need to install Access to every PC with that solution (meaning more licences to buy).
>>

>>Const dbPathName = "c:\database.mdb"
>>Const strPassword = "PASSWORD"
>>Dim Acc As Object, db As Object
>>
>>Set Acc = CreateObject("Access.Application")
>>Set db = Acc.Application.DBEngine.Workspaces(0).OpenDatabase(dbPathName, 0, False, ";pwd=" & strPassword)
>>Acc.OpenCurrentDatabase dbPathName, False
>>Set db = Nothing
>>Acc.DoCmd.OpenReport "ReportName", acPreview
>>Set Acc = Nothing
>>

>
>Any Reporting tools are free for use? As user need to pay too much
>for license.

There is a royaltee-free light-version of Crystal Reports on VB CD.

There is also the VB DataReport!

You can't ask too much when it's free!