I have a VBA application (MS Access) that uses excel functions. The application has been running smoothly for three years on Win 2000/Win XP and Office 2000/Office XP. Now we want to move the application to Win 2003 Server and Office 2003 (Not important here, we want to publish the application via Citrix). My problem is when regular users sign in to the server, following errors occur:
"Method 'FileSearch' of object'_Application' failed".
"Method 'SaveAs' of object '_Worksheet' failed".
But if an administrator sign in the server, no error occurs.
Obviously, the problem is related to permission on something (DLL or Registry?). I don't know how FileSearch and SaveAs work internally and what DLL or Registry they are associated with. Anyone has experience on this?
Thank you in advance.
"Method 'FileSearch' of object'_Application' failed".
"Method 'SaveAs' of object '_Worksheet' failed".
But if an administrator sign in the server, no error occurs.
Obviously, the problem is related to permission on something (DLL or Registry?). I don't know how FileSearch and SaveAs work internally and what DLL or Registry they are associated with. Anyone has experience on this?
Thank you in advance.