Results 1 to 2 of 2

access integration help

  1. #1
    vinwin06 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    4

    access integration help

    hello,
    I need an suggestion from you all. I have access
    database with forms,reports, queries created on
    it. but now I want upload into SharePoint . I have
    few questions on this
    1. can we able to see access forms in
    SharePoint? yes means how I can do that?
    2. the database all the objects I have uploaded its
    viewable to everyone without having access
    installed on their system.?
    3. using the database I have uploaded can we
    create user interface forms in SharePoint?
    4.any other alternative option for showing the
    form view in SharePoint?
    all your responses will be useful for me
    thanks in advance.

  2. #2
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Let me start by saying that I've researched this, but never done it.

    The process of moving an Access database to Sharepoint is not trivial. I've seen writeups of how to move data up, when you have tables that reference each other, and they involved a number of steps to relink the items. At least, it appears that you need to create a web version of the forms.
    http://sharepointmd.blogspot.no/2010...tabase-to.html

    That being said, depending on how big your application is, you might just try the wizards on a backup copy of your database and see what breaks.
    http://technet.microsoft.com/en-us/m...04.access.aspx

    Apparently the file must be in Access 2007 (accdb) or newer to use the wizards.
    http://office.microsoft.com/en-us/ac...010131468.aspx

    The most important thing when doing a demonstration/test move will be to TEST every aspect of the post-migration system that you can. Get users involved as much as possible, as early as possible, because Sharepoint doesn't have all the same features as Access, and you can't depend on it announcing what it didn't do (or on yourself understanding what it said if it *did* announce itself).

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

Similar Threads

  1. real-time data integration of csv file into access
    By nlsoe in forum Import/Export Data
    Replies: 4
    Last Post: 10-17-2012, 06:57 AM
  2. Access 2007 - Integration with Excel
    By cat713 in forum Import/Export Data
    Replies: 3
    Last Post: 07-27-2012, 01:32 PM
  3. Access integration with word and outlook
    By Abacus1234 in forum Access
    Replies: 0
    Last Post: 11-10-2011, 10:06 AM
  4. Replies: 1
    Last Post: 09-29-2009, 04:34 AM
  5. Replies: 0
    Last Post: 03-02-2009, 10:59 AM

Posting Permissions

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