I've got a VB6 database front-end, calling an Access '97 db using ADO, reporting with CR4.

The program and it's db (and the report templates) are located on the server, it is run from the remote workstations by pulling a shortcut from the exe on the server to the workstation. I've sorted out all the access privileges for the db connection (yay) so the program itself runs fine.

If I run the program from the server, I can bring up the report windows, no problemo. The trouble I have is, I can't open a report window from the remote workstations

As with all CR4 problems, there is a deafening silence when something is wrong, no error message to indicate what the problem might be.

I've loaded all the runtimes (VB, DCOM, MDAC, Jet AND CR4) onto the workstations. Anyone have any idea what could be going on? thanks, Peter