lucy.randles@synectics-solutions.com wrote:
[color=blue]
> 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.[/color]
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
