Question Microsoft Query do not connect DB Access with password

Eichenbaum

New member
Local time
Today, 17:05
Joined
Jul 22, 2011
Messages
8
Hi,

I'm trying to connect in a excel spreadsheet an Access Query using MS-Query. It works fine but only if the Database is not password protected.

In the menu Data in Excel I choose :
From other Sources > From Microsoft Query, select the database and then prompts a dialog box to input login and password.
The standard login in this box is 'admin'. I write the correct password but always excel returns me 'Not a valid password'. I tried with a blank login name but does not have success.

Anyone have an idea why it does not work?

Many thanks in Advance,
Markus
 
Last edited:

Users who are viewing this thread

Back
Top Bottom