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

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"