InfoPath Access Sharepoint

[sabina]

Hello! Please I need help.
I have my database in Access 2007, my forms are in InfoPath (based on my database)and I need to post those forms to SharePoint. My problem is that the users (who will fill in the form) dont have InfoPath, the only solution is to create a browser-compliance form in InfoPath, but I cant do it with Access database. It works only with SQL server database. Is there any easy way to convert Access database to SQL server format (I am not a programmer)? Or may be there are some other solutions I can use to post my forms online (preferably to SharePOint) and use Access database.

 

[Banana]

Why not have your InfoPath post the information to SharePoint lists and have your Access link to the same lists?

 

[sabina]

Why not have your InfoPath post the information to SharePoint lists and have your Access link to the same lists?

Have you ever tried it? If I understand it right you cant open InfoPath forms if you you dont have InfoPath on you computer unless you created a special browser-compliance form, but you cant create it based on Access database, you can create it only based on Microsoft SQL Server database format.

 

[Banana]

I just opened InfoPath 2010 to refresh my memory -- I can see that we can base a InfoPath on a SharePoint list but we can't submit data to it - the built-options are following:

Email
Document Library
Web Services
Hosted ASP.NET


Mind, those are the built-in options. You may be able to do more if you can write code but that requires the form to be fully trusted.

If your 2007 allow you to submit data to SQL Server directly (I didn't see it in my 2010 -- I can see it listed for Data Sources but not as a place to submit data -- so you can't use it as a source to submit the data), then do just that. Your Access database can then link to the tables in SQL Server.