Creating PDF from Microsoft Access

Hi,

Here's the scenario that I am having trouble with.
Currently, I have Microsoft Access that generates documents and sends to a default printer. However, I want to create PDF files instead.
But every time the document generates, it's asking for a pdf filename and saving location. Each report has the hundred pieces so it's quite difficult to manually create them. Is there anyway Acrobat can generate a filename/location automatically? I looked up 'Adobe PDF Settings' from 'Printing Preferences' and found an option called 'Adobe PDF Output Folder' but it's not useful for me because I need Acrobat to generate sequential numbered PDF(1.pdf, 2.pdf, 3.pdf...) so that I can combine them later, which is next question.
Is there anyway Acrobat can combine these individual files to one automatically?
I have Acrobat 8 Pro and MS Access 2003 on Windows XP pro.
Thanks in advance.