+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Using MS Access to read and update content and libraries

Using MS Access to read and update content and libraries

4 posts, 1 answered
  1. Marco
    Marco avatar
    3 posts
    Registered:
    01 Mar 2012
    26 Aug 2013
    Link to this post
    Is it somehow possible to use MS Access to read and eventually update Sitefinity content? I'm asking because MS Access is able to read and update SharePoint lists and libraries so I was wondering.

    I need to store in an MS Access DB urls of some documents stored in sitefinity libraries. If I could have a sort of linked table that queries a library and returns document name, url, author and so on...

    Thank you
  2. Daniel Plomp
    Daniel Plomp avatar
    952 posts
    Registered:
    18 Feb 2004
    27 Aug 2013 in reply to Marco
    Link to this post
    Hi Marco,

    I'm not sure if that would be a good idea, since you would be accessing the tables directly. Better would be to see if you can manage to update this database from Sitefinity?

    You maybe could define an Entity Model based on your MS Access database. Then you can write a module or just a simple WebForms page to use this new Entity Model together with the Sitefinity APIs to do your stuff.

    If you have any questions, let me know?

    Kind regards,
    Daniel
    Answered
  3. Marco
    Marco avatar
    3 posts
    Registered:
    01 Mar 2012
    27 Aug 2013
    Link to this post
    Hi Daniel,

    I think you are right. This is a better approach.

    Thank you,
    Marco
  4. Nayden Gochev
    Nayden Gochev avatar
    32 posts
    Registered:
    03 Nov 2014
    27 Aug 2013
    Link to this post
    Hi Macro,
    it is not recommended to make any database changes directly and not going using our API.

    Because this may lead to unmaintainable state of your database and big big issues in future Sitefinity version and schema updates.



    Regards,
    Nayden Gochev
    Telerik
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
4 posts, 1 answered