Hi,
You can take a data connection to a form library even main data connection is to an access database.
Follow these steps to take data connection.
Tools->Data connections-> add->Submit Data->To a document library on a SharePoint site->Give document library path and finish the data connection.
By using this data connection you can submit the form to SharePoint form library.