PMT SharePoint Access Setup
Download and set up the PMT Access database from SharePoint.
Prerequisites: Microsoft Access installed, PMT SharePoint access
Navigate to the SharePoint Site
- Open a browser and navigate to the SharePoint URL above.
- Sign in with your Microsoft credentials if prompted.
- You should see the document library with shared files.
Download the Database Files
- Locate the PMT_Access.zip file on the SharePoint site.
- Click the three-dot menu (…) next to the file.
- Select Download.
- The ZIP file will download to your Downloads folder.
Do not use OneDrive Sync
Do not use the Sync option. The database must be in a local folder that doesn't sync with OneDrive. When the database relinks its backend tables, it creates user-specific file paths — syncing these back to SharePoint would break other users' setups.
Extract the Access Folder to C:\
Recommended method:
- When the download completes, click Open file in your browser's download popup.
- Windows will open the ZIP file showing the Access folder inside.
- Drag the Access folder to your C:\ drive in File Explorer.
Alternative method:
- Open File Explorer (Win+E) and navigate to your Downloads folder.
- Double-click PMT_Access.zip to open it.
- Drag the Access folder from the ZIP to C:.
Avoid OneDrive locations
Place the files at *C:\Access* or another location not synchronized with OneDrive. Do not place in Desktop, Documents, or Pictures if those folders sync to OneDrive.
Open the PMT Database
- Open File Explorer and navigate to **C:\Access**.
- Double-click the PMT_1 file.
- Microsoft Access will launch and open the database.
Enable Content
When you open the database for the first time, Access displays a security warning banner.
- Look for the yellow security warning bar at the top of the Access window.
- Click Enable Content.
Relink Backend Tables
After enabling content, the database will prompt you to reconnect its backend tables.
- A dialog will appear: "Cannot connect to database tables. Attempt to reconnect?"
- Click Yes.
- The database relinks all backend tables to your C:\Access\ folder automatically.
- A confirmation message appears: "Database relinked successfully!"
- Click OK to continue.
The database is now ready to use in read-only mode.
Next time: Navigate to C:\Access, double-click PMT_1, click Enable Content if prompted, and start working — no relinking needed.
Keep your local copy
This is your personal working copy at C:\Access. Don't delete or move the files. If you need to update the database with a new version from SharePoint, download the new ZIP and replace the Access folder.
Troubleshooting
Download not working Sign in to SharePoint with your work account and try refreshing the page. Try a different browser (Edge, Chrome, Firefox).
Can't extract ZIP file Ensure the download completed fully. Try extracting to a shorter path, or use 7-Zip if available. Confirm you have write permissions to the target folder.
Database won't open Confirm Microsoft Access is installed. Check all files were extracted from the ZIP. Verify the folder is not in a OneDrive-synced location. Try opening Access first, then File > Open.
Backend tables fail to relink Ensure all database files were extracted to the same folder and the backend file is present. Close and reopen the database. Verify the folder path has no special characters. Contact your database administrator if the problem persists.
Security warning appears every time Add the folder to Trusted Locations: Access > File > Options > Trust Center > Trust Center Settings > Trusted Locations. Add the path where the database is stored.