Good news,
I found that if I turn UAC off it works (if you have the same problem, UAC
is in Control Panel/User Accounts/ and click Turn User Account Control on or
off.)
But ideally, I'd like to leave it turned on and fix the problem correctly.
Thanks
Paul
"paul" <paul@dontemailme.com> wrote in message
news:exGyIZagHHA.5044@TK2MSFTNGP05.phx.gbl...
> 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
>
>
>
>