ODBC--Connection to 'Database' failed

[Guest]

My co-worker and I both use the same computer, depending on who needs it. He
logs into the computer under his own username, accesses the network, opens
this .mdb file, and runs a query, and it works for him. At a certain point it
asks him for his password, and he enters the password which he uses for
"Banner", which is an application we use to manage the very same database
information that this .mdb file contains. I believe the tables are actually
part of a different database (Oracle, I think), and are only linked to by the
..mdb. Anyway, it works fine for him. When I log in under my username and open
the same file and try to run the same query, I get this error:

ODBC--Connection to 'Database' failed

It never even asks me for my password. What am I doing wrong?

 

[Guest]

Have you defined on your ODBC connection the database you working with?
Check the odbc in your administrative tool in windows for your odbc
connection, when you define it, define it to work with authentication, that
way it wont ask for password.

I work with SQL server, I hope you need the same setting.