ODBC Microsoft Access Driver Login Failed

B

bhay

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?
 
W

Wessel Troost

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC Microsoft Access Driver Login Failed 0
sqlite-odbc write conflict 2
Working outlook via vba code with xlsx - error 0
Incorporating the User Profile location into a document template path 1
AddPicturesToShapes 0
Active Content in this file is blocked issue 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top