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