Hi,
I have several Microsoft Access 2000 reports that show
data from a MSSQL database.

I would like to execute Access and display reports from
the FoxPro 5.0 form.
This code...
objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase(mdbName)
objAccess.Visible = .T.
objAccess.DoCmd.OpenReport(rptName)
...has 2 problems:
First problem: I can't preview report. It only prints to
printer.
Second problem: I get MSSQL login dialog box.

I appreciate any help.

Thanks,
Dragan