Results 1 to 4 of 4
  1. #1
    sabina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    2

    InfoPath Access Sharepoint


    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.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    The primary path to a web enabled Access form is via Sharepoint. Generally I would recommend you use Access2010 as the most sharepoint & web enabled version of Access. Purchase a textbook, and go thru the section on webforms. For many smaller organizations, for which running sharepoint is too big of a burden, you would want to look into the commercial hosting service www.AccessHosting.com

    There is no explicit demand to go to sqlserver per se to create an Access webform via Sharepoint hosting. Although buried inside sharepoint hosting is sqlserver - but it is not something you explicitly touch or develop.

    You state that you are not a programmer, so it isn't clear if this is outside your scope. Most that are at this forum are doing Access development.

    Hope this helps.

  3. #3
    sabina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    2

    InfoPath

    Hi.
    I am going to use InfoPath because I don't have Access 2010
    Thank you for you response!

    Quote Originally Posted by NTC View Post
    The primary path to a web enabled Access form is via Sharepoint. Generally I would recommend you use Access2010 as the most sharepoint & web enabled version of Access. Purchase a textbook, and go thru the section on webforms. For many smaller organizations, for which running sharepoint is too big of a burden, you would want to look into the commercial hosting service www.AccessHosting.com

    There is no explicit demand to go to sqlserver per se to create an Access webform via Sharepoint hosting. Although buried inside sharepoint hosting is sqlserver - but it is not something you explicitly touch or develop.

    You state that you are not a programmer, so it isn't clear if this is outside your scope. Most that are at this forum are doing Access development.

    Hope this helps.

  4. #4
    vt800c is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    23
    Sabina, you are not alone. Did you arrive at a solution? I'm amost down to having to redo all the forms in InfoPath.

    It's not the data issue..I got that. SharePoint can see Access tables. But I have all the input forms in Access, and I DON'T want to rewrite them in HTML. It's just forms and controls!..there HAS to be a way to convert them!
    Last edited by vt800c; 05-25-2011 at 11:07 AM. Reason: edit typos

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2003 and SharePoint
    By dbuck in forum SharePoint
    Replies: 3
    Last Post: 01-31-2011, 01:12 PM
  2. Sharepoint Access Services References
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 11-09-2010, 09:42 PM
  3. SharePoint and Access 2010
    By ksmith in forum SharePoint
    Replies: 4
    Last Post: 08-24-2010, 09:19 AM
  4. Using InfoPath under "Create Email" wizard
    By Alex in forum Import/Export Data
    Replies: 0
    Last Post: 07-21-2010, 07:30 AM
  5. Replies: 1
    Last Post: 09-26-2009, 02:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums