Our database makes PDF copies of all reports because of funding contracts and accreditation. Basic process: hit print button, system checks for previous versions (View/New/Quit), new PDF created and saved outside DB in PDF directory, file info saved in table to call up PDF later, small end dialog says its done, and PDF goes to viewer for the user to decide to Keep/Delete. There are several Dialog/Pause messages to tell the user what is going on. Using the development software, it works every time regardless of where the database is located (Single or LAN). PDFs are created and stored on the correct PDF drive. The LAN is MS Small Business Server 2003 with all current patches and updates.
The compiled version works great as a single user on a single machine. Change RBase.dat to the Drive Y on the LAN, recompile, and everything works as planned except it will not create the report PDFs. The end dialog skips out of order and only comes up after the menu with the print button is exited. It then goes to the Keep/Delete screen. The PDF file name is in the PDF directory with 1Kb size. If the PDF system is stripped out for a simple print version, it prints the report as expected. I have reordered/removed components of the PDF system without any performance change. I am assuming this is a LAN issue involved with creating files because it works in single machine mode. I would also expect non-R:Base file issues and we have not had any. I cannot explain why the development version works on the multi-user LAN except it always has so I know the code is working. The v8 version worked in every setting (single or LAN), but I realize v9 is more complicated. Going through the v9 compiler manual it looks like I hit the right compiler set up since basically everything else works. Where do I look? Trace and Echo do not ID any problems. This is one of those spots where I am drifting outside my knowledge base, but not the first time and surely not the last. Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected]
