Results 1 to 4 of 4

Thread: How to Link your Access DB to Sharepoint?

  1. #1
    Board Regular
    Join Date
    May 2007
    Posts
    588
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default How to Link your Access DB to Sharepoint?

    I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?

  2. #2
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,492
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to Link your Access DB to Sharepoint?

    Not that I know of. It sounds like a bad idea since Access is not for use over http networks.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  3. #3
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,722
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Link your Access DB to Sharepoint?

    FWIW, M$ has stopped supporting integration of Access with SharePoint if I'm not mistaken. For a multi user db, everybody should have their own front end connected to the back end tables on a network share - no wifi.
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

  4. #4
    Board Regular
    Join Date
    Jul 2010
    Posts
    459
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Link your Access DB to Sharepoint?

    Access supports migration of the back end to SharePoint, it basically creates lists within the SharePoint sites, imports your data into them and then creates a linked table in their place within the Access file. I have used this a couple of times, however, have had a couple of small issues.

    Some of my primary keys/foreign keys went out of order therefore the related data was then related to the incorrect record (this only happened with one table).
    A couple of the data types were slightly different, therefore required tweaking on the front end.

    I didn't save the FE within SharePoint, as others have said this is bad practice with Access as multiple users shouldn't be using the same FE concurrently.

    The SharePoint lists were exposed to anyone with access to that site. They can be hidden, however aren't by default.

    if you are considering trying to migrate data to SharePoint I would recommend thoroughly testing it on a copy of your file within a private SharePoint site as there are probably other compatibility issues that I didn't experience.
    Last edited by stumac; Nov 8th, 2019 at 12:33 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •