10-30-2014 07:07 AM
Well I had a quick glance at those files, however I don't have time to debug all that. It could be any number of things i.e. change in database (you are connecting to database) - password expired, user accounts etc. It could be access to the area your working on access rights, maybe some data is missing somewhere along the line etc. As mentioned numerous possible issues, and you are the only one with access to all the parts.
I would recommend going through each individual part, i.e. stepping through the code taking it out of macros if necessary, to identify exactly which part is not working. Once you identify what part is not working, assess what inputs there are, for instance if it is the step with the database, then check through other methods that you can access and extract the data. If you find you can't access the data then check with your DB guys, if you can then check you have SAS/Access installed. Etc.