Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

ODBC Microsoft Access Driver Login Failed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bhay@nascospg.com - 18 Jul 2007 15:26 GMT
I am using Excel 2003.  I have an Excel file that uses a query to obtain data
from an Access database.  We have changed the location of this database but I
have not been able to correct the path of this database in the Excel file.  I
am getting the below error.

"ODBC Microsoft Access Driver Login Failed

You do not have the necessary permissions to use the "Old Path of Database"
object.  Have your administrator or the person who created this object
establish the appropriate permissions for you"

I have already tried the module codes to change this within the Visual Basic
Editor and I receive an error message of "This query cannot be edited by the
Query Wizard."

How can I change this path?
Wessel Troost - 19 Jul 2007 15:52 GMT
> How can I change this path?

Use the Back button in the same wizard you use to open the Query Editor.  
This will take you back to the select ODBC data source screen, which  
allows you to change the database and it's path.

Regards,
Wessel

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.