This can no longer be done with Acrobat, you need to create the form in LiveCycle. ADBC was completely dropped with version 9.
Thank you for your reply.
So, with LiveCycle, I will be able to create a fillable pdf form, serve it out to my clients, then take the user input ID # (from the user input) and connect to my Access DB which resides on the web server. Then return a few fields from the db to fill the pdf fields?
Is this true? Would be great if I can do this.
No, there is n ot a way to directly connect to a LiveCycle form (XFA) to a database on a web server. Whether using an AcroForm (form created in Acrobat) or an XFA form, this will require some server-side programming, it cannot be done entirely with code within the PDF form. The process involves setting up the form to submit the user ID to the server, which then queres the data base and returns the data to the form, causing it to populate the corresponding fields with the data. It's difficult to convey everything you'll need to know in a forum posting, unfortunately, as there are a lot of details to consider. Some previous threads on this type of thing:
http://forums.adobe.com/thread/1038067 (See Dave's link to an instructional video)