Results 1 to 4 of 4

Looking to create a backend database linked to a Sharepoint form list. Possible

  1. #1
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45

    Looking to create a backend database linked to a Sharepoint form list. Possible


    My company uses Sharepoint and we have a form there that employees complete. I'd like to have those results feed into a linked, backend Sharepoint table, which then multiple users will use that data on front end databases.

    Is this realistic / possible?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,438
    I don't follow the question.

    Sharepoint allows the use of MS Access databases, but they can't (as far as I know) use any code, everything has to be run by macros. Are you saying the input is not a database, but maybe a word document or excel document and you want to strip information out of those and put them into your database?

  3. #3
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45
    I'm not an expert by any means with Access so I apologize if my wording is strange.

    Basically, I have a form on a Sharepoint site. I'd like the form submissions to feed directly into a backend Access table. Is that possible?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,438
    if both the form and the table are in access, to my understanding, yes, it is. I have not done anything with sharepoint though so I don't know the 'how'. I would think both the front end (user interface) and the back end (data) would have to be on the sharepoint site though.

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

Similar Threads

  1. Sharepoint Linked List keeps going offline
    By AME in forum SharePoint
    Replies: 1
    Last Post: 11-17-2016, 12:26 PM
  2. SharePoint linked list
    By Srin in forum SharePoint
    Replies: 4
    Last Post: 07-24-2015, 07:29 AM
  3. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  4. Update a record on a linked Sharepoint list
    By PoolHallJunkie in forum Programming
    Replies: 2
    Last Post: 09-24-2014, 07:25 PM
  5. Sharepoint Lists vs Web database as backend
    By is49460 in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:27 PM

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