VB6 CR4 over a network

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 :eek2:

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

bump ... any ideas anyone?

Sorry... I know this isn't very helpful, but CR4 :eek:
I have used CR4, but back then I was developing apps in VB3 on Windows 3.1... any chance of upgrading your CR? The latest version is 11 I think.
I know you said you've loaded all the runtimes, but it sounds like something's missing.
Good luck.

Pete,

I got the reports to come up today ... I did two things at the same time, mapped the network drive to Z:\ - thinking that maybe CR4, being 16 bit, was having a hard time reading a very long network address; and ran filemon, which showed the app whinging about a missing dll - although the app runs and shows reports on my home machine without that dll being on the system.

So probably due to the long network name.

Yes, I know CR4 is waaaay out of date, it's impossible trying to find any support or even any info at all on the net. But I'm doing these apps as a labour of love, sort of. I work in a small health clinic, as a nurse. These apps streamline the work a lot, and sometimes make the impossible a bit more feasible. But I don't get paid for doing them, so it's hard to justify forking out >$1000 for CR XI Developer edition.

thanks for your help, Peter

Glad you got it sorted out...

Cheers