How to Share an Access Form as a View-Only SharePoint Preview
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.

- 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.
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.
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.
Launch Microsoft Access 2022 and navigate to the specific form you wish to share.
Click on the 'External Data' tab located on the top ribbon, and select 'PDF or XPS' from the Export group.
Save the generated PDF file to your computer, then navigate to your designated SharePoint Document Library and click 'Upload' to add the file.
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.

Rebuild the Interface Using Microsoft Power Apps
If your users require a clickable interface rather than a static document, the best modern alternative is to recreate the form using Microsoft Power Apps connected to a SharePoint list.
Use Screenshots for Simple Visual Previews
If you strictly need to show users what the form layout looks like without any interactive data elements, an image preview is the fastest workaround.
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. Download WPS Office: Get the free WPS Office suite from the official website and install it on your PC or Mac.
- 2. Open Exported Data: Launch WPS Office and quickly open the PDF, Excel spreadsheet, or Word file you exported from your Access database.
- 3. Format and Share: Adjust the document layout, add necessary annotations, and upload the finalized file to your SharePoint view-only library.

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'.




