Results 1 to 6 of 6

Shall I even bother with Sharepoint?

  1. #1
    sparkyinak is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    22

    Shall I even bother with Sharepoint?

    I am spearheading an Access database build of hundreds of documents that I was planning on setting up the backend on SharePoint that we would need to purchase. As I do research in the SharePoint, I'm seeing issues after issues with the Access/SharePoint relationship which has me wondering is it worth it and what other options we have?

    We are a small non-profit and have Office 365 service where the OneDrive is more than enough for our document storage. My sole purpose for possibly getting SharePoint for our members have easy access to the records in the Access database since we can only store Access files in the OneDrive. Currently we can only move the file to and from the OneDrive to the computer and that can take several minutes at a time and potentially allow data to be lost or over written.



    I understand there are other servers I can use but I am concern with cost and the protection of personal information in the files. It sounds like what I read (on the internet) that Microsoft is moving away from the Access/Sharepoint relationship, and if they are, what is their planned alternative or am I over thinking the issues and should proceed with SharePoint

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,613
    I would suggest you use SQL Server Express which is free and will likely more than satisfy your needs for many years.
    It is stable, works well with Access, will not have data corruption issues such as those you will get with One Drive.
    The max size of a SSE database is 10GB
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    sparkyinak is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    22
    Iím not familiar with SQL Sever Express plus the DB contains PPI so security is paramount

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,613
    If security is important then SQL Server is an excellent choice.
    Its much more secure than Access.
    I've never used Sharepoint so I can't comment on that
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,103
    Currently we can only move the file to and from the OneDrive to the computer
    That is all you should ever do from OneDrive. Do not operate db from OneDrive, although I don't get the impression that you split the db anyway.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    (humor about talking to yourself apparently was too much for some)

  6. #6
    sparkyinak is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    22
    Not yet. Just exploring it. The more I look into, Sharepoint may not be the route fore me to take. Currently exploring SQL Express instead. Thanx all for the feedback

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

Similar Threads

  1. Replies: 0
    Last Post: 09-18-2017, 09:02 AM
  2. Using Sharepoint?
    By ayupchap in forum SharePoint
    Replies: 1
    Last Post: 03-27-2014, 01:36 PM
  3. Replies: 0
    Last Post: 03-24-2014, 09:35 AM
  4. Sharepoint?
    By Durks123 in forum SharePoint
    Replies: 1
    Last Post: 12-04-2013, 05:43 PM
  5. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 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