Fix Access 2016 Property Not Found Error When Exporting to SharePoint
Question details
The user is trying to resolve an error preventing them from exporting an Access database table to a SharePoint site.
- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Exporting a linked table from the front-end of a split Access database to a SharePoint site using the Export Tables wizard.
- Observed behavior
- Microsoft Access displays a 'Property not found' error message after the user clicks the SharePoint button and chooses the destination location.
Ensure you have a stable internet connection and can successfully load your target SharePoint site URL directly in a web browser.
Export the Physical Table from the Back-End Database
Since front-end linked tables are merely references, you must open the actual back-end ACCDB file to export the physical tables directly to SharePoint.
In a split Access database architecture, the table physically exists only in the back-end file. When attempting to export from the front-end, Access tries to export the link reference itself rather than the data, which triggers the 'Property not found' error.
Save your work and completely close the front-end Access database that contains the linked tables.
Locate and open the back-end ACCDB file where your physical tables and raw data are actually stored.
In the Navigation Pane, click on the specific table you want to export to SharePoint.
Navigate to the 'External Data' or 'Database Tools' tab, click the 'SharePoint' button, and follow the wizard to complete the export process.
Verify Microsoft 365 Account and Permissions
Ensure Access 2016 is signed in with the correct Microsoft 365 account that holds edit permissions for the target SharePoint site.
Test with a New Table or Site URL
Rule out corruption in the specific table or SharePoint site by attempting an export with alternative parameters.
Looking for a Lightweight and Free Office Suite? Try WPS Office
While Microsoft Access manages specialized database tasks, your everyday document, spreadsheet, and presentation needs can be handled seamlessly with WPS Office. It provides a lightweight, free alternative to Microsoft Office suites, offering high performance and an intuitive interface.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the Software: Run the setup file and follow the on-screen prompts to complete the installation in minutes.
- 3. Open and Edit Files: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office documents without formatting loss.
Frequently Asked Questions
Why do I get a 'Property not found' error when exporting a linked table?
In a split Access database, the front-end file contains only reference links to the tables, not the physical data itself. When you try to export the link to SharePoint, Access cannot find the actual table properties, resulting in the error. Always perform the export from the back-end ACCDB file.
Can I link my front-end Access database directly to SharePoint lists?
Yes. Once you have successfully exported your back-end tables to SharePoint as lists, you can create new linked tables in your front-end Access database that point directly to those new SharePoint lists.
What permissions are required to export Access tables to SharePoint?
You need at least 'Edit' or 'Contribute' permissions on the target SharePoint site to create new lists from your exported Access tables. Make sure your connected Microsoft 365 account reflects these permissions.
What should I do if the SharePoint site URL is not accepted in Access?
Verify that the URL points to the main site or subsite level (e.g., https://domain.sharepoint.com/sites/mysite), and not directly to a specific document library or page. Test logging into the site via a web browser to confirm the URL is correct and active.
