Sage 100

Good evening. I upgraded a client last night/today from Sage 2015 STD to Sage 2018 STD and they use a number of import jobs that point to .XLSM and ODBC data sources that link to Access pass-through queries. After the upgrade, non-administrative users on the network could no longer run these imports. They get different errors each time, but they all appear something like ""File GL_CompanyMemoManagerMaintenance not found"" or other ""File XXX not found"" and the info shows Error 12 VI_ImportJobMaintenance_bus.pvc. Once IT added domain admin permissions to these users, they could run the imports. The mapped drives and locations of import files have not changed, users can access and create files in those directories, we tried using UNC path to the files in the job, and this is not ADV so no ""On Host"" checkbox available to us. Anyone heard of Windows/network security preventing users from running imports? TIA!

Use ""Design Mode"" on those pass through queries to check their properties. The location addressed in those properties may require domain admin rights.

You might also check whether something in the import process is trying to write to a temp folder on the server. I've run across this with vbscript using odbc to move Excel data. You can run FileMon and watch where the import may be trying to temporarily write files. This is something that Windows does in the background, so it's not obvious when you are checking security on file locations of your data .

Thank you both - I have sent info to client to review. I hate these types of surprises with upgrades.