Hi,\n\nI've got a W2k3 Terminal Services box with Office 2007 on it. I've managed\nto get as far as getting a working 32bit ODBC link to our Oracle DB but have\nhit a bit of a wall now. One of our users has an Access DB that connects to\nthe Oracle DB via ODBC. I've create the ODBC link and tested that - all fine\nusing their credentials. the problem comes when we try to connect to Oracle\nthrough Access. It prompts for authentication fine but then throws an\nORA-12154 error when you try to connect.\nIt would seem that Access is trying to use the 64bit ODBC manager to connect\neven though the ODBC connection for Oracle has been created using the 32bit\nODBC manager.\n\nDoes anyone know of any method to force Access to use the 32bit ODBC manager?\nAlternatively does anyone know of anything else I'm missing. I've not done\nmuch with ODBC before so may be totally missing something else.\n\nMany thanks.