'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix ODBC Microsoft Access Driver Login Failed in Word Mail Merge
Question details
The user encounters an ODBC Microsoft Access Driver Login Failed error and an unexpected administrator password prompt when attempting a Word directory mail merge connected to an Access database.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Performing a Word directory mail merge using a Microsoft Access database as the data source.
- Observed behavior
- The mail merge fails to connect, returning an ODBC driver login error and requesting an unknown administrator password, typically because the file path points to a folder or the database is stored in an unsupported cloud location.
Ensure that your Microsoft Access database file is completely closed before initiating the mail merge in Word, and verify that you have the exact local file path of the database ready.
Move the Access Database from OneDrive to a Local Drive
Active Access databases do not function correctly when hosted and shared directly from OneDrive. Moving the file locally resolves path and synchronization issues.
Cloud storage services like OneDrive are excellent for file backups, but they are not designed to host active database connections. When a Word mail merge attempts to connect to an Access database located in OneDrive, it often fails to resolve the proper file path, leading to ODBC driver errors and false password prompts.
Ensure both Microsoft Word and Microsoft Access are completely closed before attempting to move the database file.
Open File Explorer and navigate to your OneDrive folder to find the .accdb or .mdb database file used for the mail merge.
Copy the database file and paste it into a local folder on your computer's hard drive (e.g., C:\Documents) or a local LAN share.
Reopen your Word document, go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List' to browse and connect to the new local file path.
Verify the Exact Database File Name and Path
The error may occur if the Word data source connection points to the folder containing the database instead of the specific database file itself.
Try WPS Office for Seamless and Lightweight Document Management
While Microsoft Access databases can cause complex ODBC driver issues during Word mail merges, switching to WPS Office allows you to handle mail merges effortlessly using simple Excel spreadsheets or CSV files. WPS Office is a free, highly compatible alternative to Microsoft Office that is easy to use and completely lightweight.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Document: Launch WPS Writer and open your existing Word document without losing any formatting.
- 3. Use Spreadsheets for Merge: Connect your document to a WPS Spreadsheet file for a flawless and error-free mail merge experience.
Frequently Asked Questions
Why does Word ask for an administrator password during mail merge?
This usually happens when the ODBC driver cannot locate the exact Access database file or it attempts to connect to a folder instead of the database file, which triggers a default security prompt even if no password is set.
Can I host my Access database on OneDrive for a Word mail merge?
No. OneDrive is designed for file synchronization and is not suitable for hosting active Microsoft Access databases. You should use OneDrive only for backups, while keeping the active database on a local drive or LAN share.
What formats does the Access database use for mail merge?
Word mail merge typically connects to standard Microsoft Access database files, which use the .accdb (newer) or .mdb (older) file extensions.
How do I change the data source for an existing Word mail merge?
Open your Word document, go to the 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and then browse to select the correct local path of your database file.
