none
Programmatic Access to published accdb

    Question

  • Hi,

    I published an accdb to Sharepoint with Access 2010. How can I access the tables through Sharepoint?

    Are the tables lists, so that I can access them through the lists API _vti_bin/Lists.asmx ?

    Can you please show me how the query to get the content of one such table looks?

    Thanks,

    Mike

    Saturday, September 28, 2013 9:58 AM

Answers

  • Hi,

    The problem is that the thing I can access through the Webs api is just the site, which works as a collection of the actual tables in the database. The tables are called lists in Sharepoint and can be accesse through the Lists api. To do this though, you need to use the site as URL that acts as a collection of the tables. Thus, if the published database is called dbtest and you uploaded it to your account dom_42, you would use the URL http://mysite.sp-site.com/personal/dom_42/dbtest to connect to. I did not see any documentation explicitly stating that you need to use a more specific URL. So hopefully this will help others.

    Regards,

    Mike

    Sunday, October 06, 2013 11:24 AM

All replies

  • Hi again,

    I found out that an uploaded accdb is stored as a site and should therefore be accessed through the Webs api instead of the Lists api (http://msdn.microsoft.com/en-us/library/webs.webs%28v=office.12%29.aspx). I can see the name I defined for the database in sharepoint when invoking the GetWebCollection method. The problem still remains: How can I read/write a table entry in the database? There is no obvious method to call. Or do I need to look into the SiteData api? Otherwise, is there another possibility to solve the problem, for instance with Sharepoint Designer? I am pretty sure that there is a way to get data from an uploaded accdb database. It seems to be a common use case, since mdb databases can be accessed through the Lists api, and accdb is just the next generation format.

    Regards,

    Mike

    Tuesday, October 01, 2013 10:58 PM
  • Hi,

    The problem is that the thing I can access through the Webs api is just the site, which works as a collection of the actual tables in the database. The tables are called lists in Sharepoint and can be accesse through the Lists api. To do this though, you need to use the site as URL that acts as a collection of the tables. Thus, if the published database is called dbtest and you uploaded it to your account dom_42, you would use the URL http://mysite.sp-site.com/personal/dom_42/dbtest to connect to. I did not see any documentation explicitly stating that you need to use a more specific URL. So hopefully this will help others.

    Regards,

    Mike

    Sunday, October 06, 2013 11:24 AM