We have an Access app that resides on a Novell server. The app allows users to enter text data into a form, mark that data entry form as complete (or save it for future editing), file the form (which moves the record from a temporary table to a permanent table, converts a report (more or less just a dump of the record) to MS-Word, encrypts, passwords the Word doc and then distributes the Word doc as an e-mail attachment to a predefined group of managers (...got it?). NB: The Word doc is temporarily written to a subfolder prior to distribution and then is deleted.
The app has worked flawlessly for two years. Around the first week in Dec 2009, however, the app went South...
Users can complete the data entry part of the procedure, but the app blows up ('Access has encountered a problem and needs to close..., etc.). The data entered are intact, even though I'm prompted to 'repair my open database...'
I can think of dozens of ways the app could blow up over time...except that (this is the good part)...it works perfectly if run on one particular PC. That PC happens to be the one my programmer used to develop the app to a large degree. No other PC will run the app without bombing. It's almost as if that particular PC has access rights to something (perhaps the folder Word doc resides in temporarily) that no other machine has. We've tried all combinations of Novell administrator v. user, logging into the workstation locally v. active directory...etc.) to no avail. The app only works on the one PC.
The problem seems to have started around 09 Dec 2009...does anybody have any idea what might be going on here?
Thanks.
The app has worked flawlessly for two years. Around the first week in Dec 2009, however, the app went South...
Users can complete the data entry part of the procedure, but the app blows up ('Access has encountered a problem and needs to close..., etc.). The data entered are intact, even though I'm prompted to 'repair my open database...'
I can think of dozens of ways the app could blow up over time...except that (this is the good part)...it works perfectly if run on one particular PC. That PC happens to be the one my programmer used to develop the app to a large degree. No other PC will run the app without bombing. It's almost as if that particular PC has access rights to something (perhaps the folder Word doc resides in temporarily) that no other machine has. We've tried all combinations of Novell administrator v. user, logging into the workstation locally v. active directory...etc.) to no avail. The app only works on the one PC.
The problem seems to have started around 09 Dec 2009...does anybody have any idea what might be going on here?
Thanks.