SharePoint Document Issues

How to Share an Access Form as a View-Only SharePoint Preview

Anum MushtaqAnum Mushtaq Oct 26, 2026 869 views

Question details

The user wants to display an MS Access 2022 form on a SharePoint site as a clickable, interactive preview while ensuring users can only view the data without modifying the source database.

Can You Share an Access Form as a View-Only SharePoint Preview?
Product
Microsoft Access, SharePoint
Device & OS
not provided
Scenario
Presenting database forms on a shared company SharePoint portal for informational, view-only purposes.
Observed behavior
Microsoft Access forms cannot be natively shared or embedded as interactive, view-only web previews directly within modern SharePoint environments.
Before you start

Determine whether your team needs to see dynamic, up-to-date data or just a static layout of the form, as you will need to utilize exporting tools or alternative web-apps to achieve a view-only display on SharePoint.

Solution 1Recommended

Export Access Form Data as a PDF Report

Since interactive direct embedding is not feasible, exporting your form as a static PDF document allows users to safely view the layout and data on SharePoint without editing capabilities.

This is the most straightforward method to present your Access data securely. By converting the form to a PDF, you eliminate any risk of accidental database modification while maintaining the exact visual layout you designed in Access.

1
Open your Access database

Launch Microsoft Access 2022 and navigate to the specific form you wish to share.

2
Export to PDF format

Click on the 'External Data' tab located on the top ribbon, and select 'PDF or XPS' from the Export group.

3
Upload to SharePoint

Save the generated PDF file to your computer, then navigate to your designated SharePoint Document Library and click 'Upload' to add the file.

4
Display via File Viewer

On your SharePoint page, add a 'File Viewer' Web Part and link it to your uploaded PDF so users can preview the form natively in their browser.

Export Access Form Data as a PDF Report
Data Updates: PDF exports are static. If the underlying Access database is updated, you will need to generate and upload a new PDF to SharePoint to reflect those changes.
Free Microsoft Office alternative

Easily Manage Exported Access Data with WPS Office

While Microsoft Access is required to natively build and manage your databases, WPS Office provides a lightweight, free alternative for viewing, formatting, and sharing the exported database reports, spreadsheets, and PDFs to your SharePoint portal.

  1. 1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your PC or Mac.
  2. 2. Open Exported Data: Launch WPS Office and quickly open the PDF, Excel spreadsheet, or Word file you exported from your Access database.
  3. 3. Format and Share: Adjust the document layout, add necessary annotations, and upload the finalized file to your SharePoint view-only library.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PDF formats.Easily view, edit, and annotate PDF reports exported from your database forms.Lightweight and completely free to use for your daily documentation needs.Familiar, tabbed user interface ensures a seamless migration from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I embed an Access form directly into a SharePoint page?

Microsoft has officially deprecated Access Services and Access Web Apps. This means that direct, interactive embedding of Access forms into SharePoint is no longer natively supported in modern SharePoint environments.

Can I use Excel instead of Access for a view-only SharePoint preview?

Yes. Exporting your Access database view to an Excel workbook allows you to upload the .xlsx file to SharePoint. You can then use the SharePoint Excel Web Part, which provides a highly interactive but view-only spreadsheet experience for your team.

How do I restrict users from editing a SharePoint List if I rebuild the form there?

You can modify the list permissions by navigating to 'List Settings', selecting 'Permissions for this list', stopping permission inheritance, and assigning specific users 'Read' access instead of 'Contribute' or 'Edit'.