Results 1 to 3 of 3
  1. #1
    BartH_NL is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2

    Converting Forms with linked tables to SharePoint lists

    Hello,

    I have an Access database that holds a number of linked tables (to an other Access file).
    In the new situation the data I need to link to are in SharePoint lists (and the old Access file is no longer supported).
    The names of the existing tables are the same as on SharePoint.

    I know how I can make an external connection to a SharePoint list.

    What would be the best procedure to swap the linked existing tables for the new SharePoint list tables?



    Can I first break the connection to the old linked tables and then connect to the new SP lists without upsetting all Forms and Queries or should I do this in an other way?

    The reason I ask this is because I previously deleted one existing table, connected the corresponding SP list, but now I keep getting the error when I open a Form that the deleted table cannot be found (while the new table has the same name).

    Thanks for directions...

    BartH_NL

  2. #2
    Daisy509th's Avatar
    Daisy509th is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Central Texas
    Posts
    51
    If everything is the same in the tables including the name then just delete the old link tables. After that is done go to the link manager and link the new tables.

  3. #3
    BartH_NL is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2
    Hi Daisy509th,

    I already found out is wasn't a problem to swap the tables. Nevertheless we decided to dump the SharePoint lists as they are very crappy with primary keys. They assign an auto number key to every entry and it is not possible to assign combined primary keys to two or more fields.

    So if you want to store data on a central location, better use a SQL Server database or even a central Access file instead of a SharePoint list unless the data requires no advanced primary keys.

    Grtz BartH

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

Similar Threads

  1. Replies: 2
    Last Post: 07-14-2017, 05:37 AM
  2. Number format in tables stored on Sharepoint as lists
    By tim.cassey in forum SharePoint
    Replies: 0
    Last Post: 02-16-2016, 08:08 PM
  3. Help actually using Linked Lists with SharePoint
    By NathanBurley in forum SharePoint
    Replies: 8
    Last Post: 08-07-2015, 12:50 PM
  4. Slow access tables linked to sharepoint. How to fix it?
    By flamingos_usa in forum SharePoint
    Replies: 3
    Last Post: 05-03-2014, 09:36 AM
  5. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums