logon failed ... dbf files 1

[Schimsky]

Hi, I have a crystal 9 vb6 application... the crystal report runs against old dbase III files. When I use this code to start the report in my vb6 program...

Dim Application As New CRAXDRT.Application
Dim Report As CRAXDRT.Report

Set Report = Application.OpenReport("j:\scoring\nic95\dev\SchoolReport.rpt")

Report.Database.Tables(1).Location = "j:\scoring\nic95\xx"
Report.Database.Tables(2).Location = "j:\scoring\nic95\nv1"
Report.Database.Tables(3).Location = "j:\scoring\nic95\nv1"

CRViewer91.ReportSource = Report
CRViewer91.DisplayGroupTree = False
CRViewer91.ViewReport
CRViewer91.Zoom (75)

I get the error:"Logon Failed"

These are dbase files! There is no logon or password!

Does anyone know how I specify this in code?

Thanks

Steve

 

[paulmarr]

Steve,

If I cast my mind back far enough - I think you need a separate database driver for each file - or a client installed on your PC to access the dbf files.

I hope this helps

Cheers
paulmarr