These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Infusing MS Access data into PDF form

Getsummm
Registered: May 24 2007
Posts: 4

I have infused PDF forms from within .Net many times over but now I have a client that needs to perfrom this from the click of a button on an Access form. What OCX or Adobe product will allow instantiation from VBA and allow data manipulation of the form fields and view/save the result? I believe the client is using Office 2003 and PDF forms designed with the Adobe LifeCycle product.

Thanks for any help.
Randy

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
OLEDB is the only database connection that you can connect to from LiveCycle Designer. Through the use of the Microsoft OLEDB Provider for ODBC Drivers, you can also access databases identified by the ODBC data source name (DSN). You can use OLE drivers other than the Microsoft OLEDB Provider for ODBC, however the form must be certified in Acrobat before it will function at run time.

There are examples of working with PDF forms from LiveCycle and data sources and schemas available at:
http://www.adobe.com/devnet/livecycle/designer_scripting_samples.php#working_data

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.