Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-19-2017, 11:21 AM   #1
BlueJacket
Newly Registered User
 
Join Date: Jan 2017
Posts: 92
Thanks: 85
Thanked 2 Times in 2 Posts
BlueJacket is on a distinguished road
ODBC Microsoft Access Driver Login Failed

I keep getting an "ODBC Microsoft Access Driver Login Failed" error when I try to use the Word Merge function in Access 2010. I can get it to work after a bunch of steps when I do the merge through Word, but I want this to be an easy, automated process in Access for the end user. Is this because it's a split database?

I get the error after I select the word document that I want to merge with. "Could not find file C:\........\Access.mdb." I press OK and it prompts a login screen. There are no security measures in the database at this time. I click on the "Database" button and select my front end database file, select the query I need, and then Access tells me "Word was unable to open the data source." Wwhhhyyyyy, Access, wwhhhyyy?

What are the steps I can take to fix this?

BlueJacket is offline   Reply With Quote
Old 04-19-2017, 08:04 PM   #2
liddlem
Newly Registered User
 
Join Date: May 2003
Location: Queensland
Posts: 316
Thanks: 16
Thanked 13 Times in 13 Posts
liddlem is on a distinguished road
Re: ODBC Microsoft Access Driver Login Failed

Is you database called 'Access.mdb' or something else?
Also - I guess that word is asking you which TABLE/QUERY that it musty use to source the data. Are you specifying the Table/Query?
__________________
Using Win7 and Access2007/2010/2013/2016. sometimes linking to SQL back-end.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
liddlem is offline   Reply With Quote
Old 04-20-2017, 05:31 AM   #3
BlueJacket
Newly Registered User
 
Join Date: Jan 2017
Posts: 92
Thanks: 85
Thanked 2 Times in 2 Posts
BlueJacket is on a distinguished road
Re: ODBC Microsoft Access Driver Login Failed

It's called something else, "CompanyName_FE.accdb", so I never understood why it was referring to "Access.mbd" to begin with.

And yes. You have to click on the data source (in my case, a query) to start the word merge. When I use Word Merge on an unsplit database, it work fine. For whatever reason, it doesn't want to work on the Front End (which is located on my local machine) side of my split database.

BlueJacket is offline   Reply With Quote
Old 04-26-2017, 06:27 AM   #4
jabadm
Newly Registered User
 
Join Date: Apr 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
jabadm is on a distinguished road
Re: ODBC Microsoft Access Driver Login Failed

Greetings BlueJacket,

Did you find a solution to your issue? I'm having a similar problem when I attempt to do a Word Merge from a query.
jabadm is offline   Reply With Quote
Old 04-26-2017, 09:06 AM   #5
The_Doc_Man
AWF VIP
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 10,718
Thanks: 36
Thanked 850 Times in 763 Posts
The_Doc_Man is a name known to all The_Doc_Man is a name known to all The_Doc_Man is a name known to all The_Doc_Man is a name known to all The_Doc_Man is a name known to all The_Doc_Man is a name known to all
Re: ODBC Microsoft Access Driver Login Failed

Is this a domain environment? Because depending on just how tightly the security wonks tie down things, it might be that your back end has a firewall that is application sensitive. It knows about Access but wasn't expecting Word. The first time this happened to me I was a bit puzzled. But once I understood WHAT was happening, it was an easy fix. Get an ACL added to the firewall to allow use of WORD. But IF (and admittedly a big IF) this is what is happening, your security folks have to get involved.

If this is NOT a domain environment with heavy-duty firewalls, then I have no other ideas.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over six months and survived being home all day with the wife. She must really love me.
The_Doc_Man is offline   Reply With Quote
Old 04-26-2017, 11:33 AM   #6
BlueJacket
Newly Registered User
 
Join Date: Jan 2017
Posts: 92
Thanks: 85
Thanked 2 Times in 2 Posts
BlueJacket is on a distinguished road
Re: ODBC Microsoft Access Driver Login Failed

@The_Doc_Man
I'm not quite sure what you mean by domain environment. The front end is located on my machine and the backend is on a local server. I don't know what security is in place on the local server, but I do know as of right now, the only way to access it is through one of these computers.

From my research, this seems to be a common issue with a split database and mail merges based off form/query with parameters.

@jabadm
I've found that exporting the necessary info to a text file is the most common work around to this problem, which is what I have done. Another user (UncleGizmo) referred me to this site:

http://www.helenfeddema.com/Code%20Samples.htm (Use Find to search for "Merging to Word Four Ways")

Which I borrowed heavily from. My advice: Download the example database, take some time to understand the code, and then adapt it to what you need. Once I got it up and running, it automated everything very nicely and she did a good job leaving comments for each section.

BlueJacket is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object TBC General 2 04-14-2011 09:46 AM
[ODBC Microsoft Access Driver] System Resource Exceeded amegahed3 General 4 10-12-2010 07:03 AM
Question ODBC Microsoft Access Driver Optional feature not implemented diegazo General 4 05-18-2010 08:22 AM
Access connectivity error using JSP::Microsoft][ODBC Driver Manager] Data source name rekha.n.prasad General 0 03-25-2009 07:56 PM
[SOLVED] Microsoft access driver problem-odbc problem eliomas General 0 09-21-2004 02:21 AM




All times are GMT -8. The time now is 06:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World