New DB Query problem

  • Thread starter Thread starter D.P. Roberts [MCSE,MCSD,MCDBA]
  • Start date Start date
D

D.P. Roberts [MCSE,MCSD,MCDBA]

In Excel 2002, when I go to Data-Import External Data-New Database Query, I
get a "Choose Data Source" window that displays many items including Oracle,
dBase Files, Excel Files, and MS Access Database.

However, when another user logs onto the same PC and tries the same process
they don't see any of those files listed. Instead, they only see Oracle
listed. Does anyone know why this might be happening?

Thanks!
 
Probably because the rights to those other Databases are assigned by
username from the MIS dept.

Vaya con Dios,
Chuck, CABGx3
 
Actually, it defaults to your User Data sources (My Data Sources, in
XP/2k3), which are blocked off by Profile (you have a different profile from
the other users). You can either create and save a File Data source, or
possibly setup a System Data source.

Open up ODBC Administrator in the Administrative tools for more information.

I hope this helps.
 
You must log in or register to reply here.

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

Source of Data Files? 4
Excel 2003 case sensitive problems with New Database Query 1
Linking Access Query to Excel make DB Read Only 1
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 6
relative path in OLEDB string 3
"Double hop" problem 4
Linking via 'New Database Query' on a shared network 1
External data connection needs separate login for each query 1

Back
Top