Access 2007 link table login

[wesbird]

Hi
I am migrating my Access 2003 to 2007. There a lot of link tables from
Oracle in my mdb file. when my applicaiton running, I have to code to login
Oracle:

Dim wsp As Workspace
Set wsp = DBEngine.CreateWorkspace("xxx", "xxx", "xxx", dbUseODBC)
Set dbs = OpenDatabase("", False, True, strConnect) ' connect via
regular ODBC
'Close the database. The login is still cached so that it is available
for any
'Access object that needs it during the same session.
dbs.Close

This code works great in 2003 but not in 2007. How I can do it in 2007?


Thank you a lot
Wes