Converting reports to pdf (1 Viewer)

[jer]

Hi,
Im converting my reports to pdf so that i can basically have an electronic book of all my reports. However, after clicking the convert to pdf button, after about 200 convertions, it says that the amount is too large and stops converting and just finishes the 200 it was working on. How do I get over this??

Thanks in advance,
Jer

 

[Alansidman]

Are the pdf files stored in Access? Access has a size limitation of 2 G. How big is your Access file now? Have you tried running a compact and repair and see if that helps?

 

[vbaInet]

Perhaps you can show us the code you're using to do this as well?