L
ljrandles
Guest
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. All the examples I can find use SQL datasources, and I don't know how to amend them to log into Oracle.
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. All the examples I can find use SQL datasources, and I don't know how to amend them to log into Oracle.
