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.
 
Back
Top