Oracle Automated Login via MS Access

[lucy.randles]

We're implementing automated logins to Oracle, using the users NT
password. However, when trying to link in tables through the ODBC
datasource in MS Access, we're encountering errors. Because users
local tables are kept on the domain, the path comes up as
domainname/username.tablename. It appears that Access doesn't like the
/, and therefore falls over. When linking tables that aren't proceded
by the / it works fine.

Is there any way round this? Can a VBA module be written for example,
that puts quotes round the table path to bring it back. I've had a dig
around, but can't find anything that will help me with this problem.

Thanks,

Lucy Randles

[Tim Marshall]

lu**********@synectics-solutions.com wrote:

We're implementing automated logins to Oracle, using the users NT
password. However, when trying to link in tables through the ODBC
datasource in MS Access, we're encountering errors. Because users
local tables are kept on the domain, the path comes up as
domainname/username.tablename. It appears that Access doesn't like the
/, and therefore falls over. When linking tables that aren't proceded
by the / it works fine.

Is there any way round this? Can a VBA module be written for example,
that puts quotes round the table path to bring it back. I've had a dig
around, but can't find anything that will help me with this problem.

I don't have an answer for the specific question, but I'd use pass
through queries in this particular circumstance. It's a lot more work
than linked tables, though, but it does bypass some of the problems some
Oracle schemae generate with ODBC linked tables.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me