InfoPath Dev

Is it possible to connect an InfoPath form to an access database to bring data into a form? I know this is possible with SQL but the data resides in MS Access currently. Are there any alternatives to SQL like SQL Lite? My purpose is to integrate Access data into and email template that which can be emailed out directly based on rules. I am trying to automate some portions of an administration position.

 merrile,

Create a new form, use Advanced Form Templates, Database.  Set the required MS Access DB as the primary data source....

Hope this helps.

L mac

So I can bring data into the for that way? I want to use data from an access database the help me complete an email I want to send out.

 Merrile,

 Yes you can receive data, and write data to either MS SQL databases or MS Access Databases, and create a separate data connection to send out as an e-mail.