4 Ways To Fix Access Could Not Connect To SharePoint issue

Fix Access Could Not Connect To SharePoint

Are you unable to connect Access database with SharePoint?  As each time you try to do so you are getting the same error message “Microsoft Access could not connect to the site you specified SharePoint”?

Don’t have any idea why your Microsoft Access could not connect to SharePoint and how to fix this issue?

No need to get worried, as our today’s post is particularly about how to solve the problem of connecting to SharePoint from Access.

User’s Query:

We have chosen this topic to answer as many users find reporting about this particular Microsoft Access could not connect to the site you specified sharepoint error in several of the forum sites. Here is one such user query, just take a look:

Hi:

I am using Access 2003 to link to lists on Sharepoint with an Office 365 account. I am getting intermittent problems connecting to lists on the Sharepoint account. Sometimes it works, sometimes I get these error messages:

“The site you specified does not support importing data to a Microsoft Office Access database. The site must be running Windows Sharepoint Services”

I *think* the above message might have *something* to do with addons for the browser that need to be installed, but I don’t know for sure.

“Microsoft Office Access could not connect to the site you specified. Verify the address of the site or contact your site administrator.

This one, I have no idea…

Thanks!

Source: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other-mso_archive/access-and-sharepoint-could-not-connect-to-the/0a56b500-323a-41ac-aec7-ac2d8fe9f0ed

What Causes Access Could Not Connect To Sharepoint Problem ?

Well, this Microsoft Access could not connect to SharePoint problem mainly arises when you try to open an already existing linked table in the access database that doesn’t contain any locally saved credential for the SharePoint site. This saved credential can be the already existing cookies of internet explorer or the credential present in the Windows Credential Manager.

How To Fix Microsoft Access Could Not Connect To SharePoint Issue?

Try the following workarounds to Microsoft Access could not connect to the site you specified SharePoint.

Method 1: Add The Enablelegacylistauth Registry Entry

Note:

If you are an Access 2016 database user then make a click on the Run version 1804 (build 9226.2114) or MSI version (build 16.0.4690.1000) or install some later version installed in order to opt for this method.

Here is the complete step to add EnableLegacyListAuth registry entry. Just follow it carefully.

  1. At first, open your Registry Editor. After that locate and choose the following registry subkey:

For 32-bit Office on 32-bit Windows or 64-bit Office on 64-bit Windows

  • For Access 2016

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\List

  • For Access 2013

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\List

For 32-bit Office on 64-bit Windows

  • For Access 2016

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\List

  • For Access 2013

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\15.0\List

  1. Go to the edit Now hit the new option and then hit the DWORD Value.
  2. Enter the EnableLegacyListAuth and then from your keyboard hit the enter
  3. Make a right-click on EnableLegacyListAuth and then choose the Modify option.
  4. Now from the Value data box, you have to type 1 and then hit the OK button.
  5. Look for the following registry key:
  • For Access 2016

HKCU\SOFTWARE\Microsoft\Office\16.0\Common\Identity

  • For Access 2013

HKCU\SOFTWARE\Microsoft\Office\15.0\Common\Identity

  1. It’s compulsory to enter the value of EnableADALis 0.
  2. Now take an exit from the Registry Editor.

Method 2: Refresh The List

To refresh the list, follow these steps:

  1. Open your Windows Task Manager. From its running app list choose Microsoft Access and hit the End task button.
  2. Now reopen your Access database.
  3. Make a right-click on the Access linked table and choose More OptionsRefresh List.
  4. Log in by making use of the credentials.

Method 3: Programmatically Relink The List

Follow these below-given steps for relinking up the SharePoint list:

  1. Open your Windows Task Manager. From its running app list choose Microsoft Access and hit the End task button.
  2. Now reopen the database and then create a new module.
  3. In the VBA code, opt for the RefreshLink method of the TableDefs collection for the linked tables:

VBCopy

Public Function TableRelinkSample()

           CurrentDb.TableDefs(“<TableName>”).RefreshLink

     End Function

Note:

If there is multiple linked SharePoint list, then call for the RefreshLink for each of the single tables only once.

  1. Now call the TableRelinkSample()function from startup code or AutoExec macro in the database.

Fix 4# Repair Corrupted Access Database 

There are situation occurs where this access database denies getting connect due to corruption of the database file. in that case, firstly you need to repair corrupt Access database file. After that only you will be able to set up the connection between your database and SharePoint.

For this, you need to use Access Repair And Recovery Tool as it is the most appropriate tool for fixing up any corruption issue that occurred in your Access Database.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

If you are unable to apply the above given manual methods due to any reason. Or want to get rid of MS Access Database corruption issue then using Access Repair & Recovery tool is the best option. This recovery software is one of the best ways to get rid of any kind of errors and restore your damaged database without using any backup.

Steps To Repair And Recover MS Access Database:

Wrap Up:

After establishing a connection between the Access database with SharePoint lists you can easily work with the lists either with the SharePoint site or using the linked tables in Access.

Besides this, you can also enter the data with the use of form or table in the Access database or just by editing up the list present on the SharePoint site. So, now you can take complete advantage of linked lists between SharePoint and Access database without any issue.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.