Re: Infopath to Access DB on Sharepoint 2007

jchapin — Thu, 14 Jul 2011 14:42:41 GMT

I am also having this problem. Are there any solutions? And if not, could you please post here and let us know?

Infopath to Access DB on Sharepoint 2007

psturmey — Wed, 13 May 2009 09:00:25 GMT

Hi,

Can anyone give some advice if what I'm trying to achieve is possible?

I've created an Infopath 2007 Form which queries an Access 2007 Database to populate a repeating table.
As part of the development the access database was stored on my local C: drive.

I would now like to publish the Form to Sharepoint 2007 and move the Database to a Sharepoint Document library.

I've uploaded the database but when I try to change my data connection in InfoPath to point at Sharepoint it does'nt like it.

"An unspecified error occurred while attempting to connect to the data source. Microsoft Office InfoPath supports only Microsoft SQL Server and Microsoft Access databases. Check the connection to ensure it uses one of those two databases."

Having the database stored in Sharepoint would be my ideal solution as it's easier to grant access for our remote users as apposed to a network file share.

Has anyone come across this problem before and found a way round it?

thanks

Paul Sturmey

General

Re: Infopath to Access DB on Sharepoint 2007

Infopath to Access DB on Sharepoint 2007