Sign in
Microsoft.com
 
Microsoft Online Services TechCenter
 
 
 
Microsoft Online Services TechCenter > Microsoft Online Services Forums > Microsoft Online: SharePoint Online > Edit Microsoft access database online in Microsoft Sharepoint Online
Ask a questionAsk a question
Search Forums:
 

AnswerEdit Microsoft access database online in Microsoft Sharepoint Online

  • Tuesday, October 20, 2009 11:53 AMGreensquare Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hello,

    I have uploaded a few Microsoft Access databases in Microsoft Sharepoint Online. When I select these databases in Sharepoint, it gives me two options: I can view the database online or I can modify it. To modify the database I first have to download it, modify it on my computer and then export it again to Sharepoint. This takes a lot of time. Isn't there a way to modify the database online at Sharepoint and then save it?

    Thanks in advance,
    Ricardo
    • Moved byMike Walsh MVPMVPTuesday, October 20, 2009 2:16 PMSP Online q (From:SharePoint - Enterprise Content Management)
    •  
     

Answers

All Replies

  • Tuesday, October 20, 2009 4:23 PMMcGeeky Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Ricardo. Have you tried the Access/SharePoint synchronisation feature? This will give you a completely different way of working which might suit your needs better.

    In this mode, all your Access tables are stored as SharePoint lists. Your local Access database maintains links from the tables to the remote SharePoint lists: anytime you change a row in the local table the change gets pushed up in to the SharePoint list and vice versa.

    Have a look at the External Data ribbon in Access; this has options to push your existing database up in to SharePoint or connect your database to an existing SharePoint list.

    Hope this helps.

    Myles

    http://twitter.com/mjthinkscape
     
  • Wednesday, October 21, 2009 11:16 PMjwsharepoint Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Myles,

    Do you know if this will work with access databases that have linked tables to SQL?

    We have some Access databases that have the data stored in linked SQL tables & Views.  I have a feeling that it is not supported yet though, but may be in 2010.

    Thanks,
    jw.
     
  • Thursday, October 22, 2009 7:01 AMMcGeeky Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    Hi jw. SharePoint Online does not have the concept of linked SQL tables. However, there is nothing stopping you from having those linked SQL tables in your Access database running alongside the linked SharePoint Online tables.

    This is possible because you can selectively link an Access table to a SharePoint Online list.

    Do you have a specific business scenario in mind?

    Regards,

    Myles

    http://twitter.com/mjthinkscape
     
  • Thursday, October 22, 2009 7:13 AMMcGeeky Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I should clarify that you can set up a datasource using SharePoint Designer to access a SQL database. But that has no relationship to a linked SQL table in Access.

    Regards,

    Myles
     
  • Friday, October 23, 2009 4:39 AMjwsharepoint Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Thanks Myles,

    We just have some access databases currently running through citrix.  If I could get them running through SharePoint instead, that would be great.
    I'll have a look at setting up some datasources within Designer.

    I saw through the following video that composites will be available in SharePoint 2010 and having a link between SharePoint and SQl directly will be available.  But i am not sure if this will be available in BPOS.


    mms://msstudios.wmod.llnwd.net/a2294/o21/msstudios/0910/1001501/1001501_SharePoint2010_Composites_JR_1000k.wmv

    jw.

     
  • Friday, October 23, 2009 8:10 AMMcGeeky Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi jw. Thanks for that link... wow, the connectivity to SQL looks brilliant. I hope that makes it in to SharePoint Online.

    Good luck with SharePoint Designer datasources, I hope it works out for you.

    Regards,

    Myles