I have a database on a remote computer that has several reports that can be generated. Is there anyway to create a PDF of one of those reports and download it to my main computer?
Thank you for your input.
I have a database on a remote computer that has several reports that can be generated. Is there anyway to create a PDF of one of those reports and download it to my main computer?
Thank you for your input.
Perhaps if the remote computer gives permission to share its drive, code in your local Access db can open the other database as an object in VBA and manipulate it. Must be able to map to the other computer. I don't have any experience in this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That is probably how I would go about it. IIRC, you just need to create a Workstation Object. I think I uploaded an example here within the last few weeks. However, there may be other options depending on what "remote" means and how you are accessing this DB.
It sounds like this may be an option, I looked for your uploaded example and couldn't fined it. Could you direct me to it? Thank You.
I got the Object name wrong it is a Workspace, not a Workgroup.
https://www.accessforums.net/modules...tml#post279574