This took me just short of forever to figure out what my real problem actually is. I have a microsoft access database using the ReportToPDF function found at http://www.lebans.com/reporttopdf.htm
. It turns access snapshot reports into PDFs using two DLL's placed in the databse folder or system32 folder. An amazing little program. On my development machine, a 2003 server (without Terminal Services installed) that I use RDP to access, it works great. Once I installed the database on my production Terminal Server, it lost the ability to embed fonts into the PDF. To recap my hardware & software scenario,
2003 Development Server - Access 2003 Installed - Remote Access vis RDP - Works great
2003 Production Terminal Server (Terminal Services & Access Runtime Installed) - Works but with Limited Functionality/Won't Embed Fonts
Thinking it had to be some minor difference between the two machines, I checked available fonts, user permissions, compared installed programs, duplicated available printers, uninstalled programs, etc. Nothing worked. I finally realized it was only working on servers without Terminal Services installed. So, something must be happening when access runtime is installed as a terminal services app because that's when I lose the ability to do it, even if I give the test account domain admin privaleges. When runtime is installed normally, it works fine. I even installed a full version of access 2003 as an available terminal server application and that didn't work either, so it's not just runtime, it's effecting access period.
At this point, I'm completely stumped. I'm just looking for some suggestions or ideas on what you'd try because I don't know what to do next. This program works so slick that I want to be able to use it, but I guess I'm open to alternative suggestions that can be coded and work without user intervention.
P.S. I have another question open touching on this that I asked before truly figuring out what my problem was. If someone can provide an answer to this one, I'll give you those 500 points as well.