jetyun
asked on
I have this error "Error opening file" msg
I used Ms Access XP as database and Crystal Report to preview the report for the data from that database. And i run this process under Windows XP. When i verify the database from crystal report itself it is working fine but when execute that report from vb, it's prompt me this msg "Error opening file. FIle could not be opened: XXX, at file location: "xxx.mdb".
I have no idea why this error can occur in windows xp!
I have no idea why this error can occur in windows xp!
ASKER
Dear mlmcc,
I used code below;
With rptReport
.DataFiles(0) = gclsDatabase.TempDB.Name
.WindowState = crptMaximized
.WindowTitle = Caption
.ReportFileName = App.Path & "\report\Report.RPT"
.Destination = 0
.Action = 1
End With
pls advise...
I used code below;
With rptReport
.DataFiles(0) = gclsDatabase.TempDB.Name
.WindowState = crptMaximized
.WindowTitle = Caption
.ReportFileName = App.Path & "\report\Report.RPT"
.Destination = 0
.Action = 1
End With
pls advise...
I don't think this is it but CR arrays are 1 based so i think
.DataFiles(0) = gclsDatabase.TempDB.Name
should be
.DataFiles(1) = gclsDatabase.TempDB.Name
WHat does gclsDatabase.TempDB.Name equal? Does the database exist?
I have not used the .datafiles option so I am uncertain what it does.
mlmcc
.DataFiles(0) = gclsDatabase.TempDB.Name
should be
.DataFiles(1) = gclsDatabase.TempDB.Name
WHat does gclsDatabase.TempDB.Name equal? Does the database exist?
I have not used the .datafiles option so I am uncertain what it does.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc