Code won't run on all PC's

[esskaykay]

Not sure if this is a database question or general PC concern –

We have a DB tracking engineering drawings. It includes a QueryByForm which lists appropriate files. It has a command button that opens the corresponding file with our CAD program. I did all the testing on my machine and it works great. I copied to others and it bombs. It says it can’t locate the file which resides on our server in folder Z:\plans\. If I move some of the files to their local machine as a test (i.e., C:\plans\), and change the code to look in C:\plans\ instead of Z:\plans\, it works fine. All persons have the same permission on the server as I do – some on XP, others on Win2K. So something’s apparently configured differently on my machine compared to theirs – but, I have no idea what.

Any suggestions would be greatly appreciated.

Thanks,
SKK

 

[namliam]

Try using the UNC path instead of the Z:\ the drive may be mapped differently, but the UNC will always work if people have access to it.

 

[esskaykay]

Already tried that (\\city_server\cad_files\plans\) with same results. - works on my machine, not theirs.

SKK

 

[namliam]

They dont have CAD installed or the CAD files not linked to it?

Do they have the permissions needed on the Z:\Cad folder? Perhaps they have read only rights but CAD needs to write a temp file to it when opening the file (much like access needs full rights?)

 

[esskaykay]

Everyone has same CAD program, same mapped drives, same network permissions.

SKK

 

[namliam]

I am just gambling here... But running out of ideas fast...

I am sure everyone has the same CAD program, but do they have the files properly mapped to start CAD?

I am fresh out of ideas tho

 

[esskaykay]

Yes all are configured the same.
I hear you - I'm out of ideas myself...

Thanks for your time,
SKK