View Single Post
Old 04-18-2007   #1 (permalink)
paul


 
 

ODBC permission problem

Hi,
I have just recieved my new Dell PC With Vista Business installed.

First I have joined our company domain, and created accounts in the user
control panel that have admin rights.

I have installed the ORACLE ODBC client whilst logged in as the computer
administrator, and then set up the relevant system DSN.

Then when I log in to my MSAccess DB it works fine, but when I log out as
the administrator, and log in with my usual username (Which is also an
administrator), I cannot read link tables.


I get an error "SQL_HANDLE_ENV failed (#0)"

If I test the system DSN in the ODBC Datasource Administrator it says test
successfull.

I am thinking that maybe there is a file that I do not have privelidges to
read, maybe a temp file but I cannot figure it out.

Can anybody help ?

Thanks




My System SpecsSystem Spec