D
Dennis
Access 2002 on Win2K....
When I go in to do a "global refresh" (Select All) of linked Oracle tables,
it *says* it refreshed successfully. (It does prompt me for the database
username and password, which I enter correctly.) However, when I attempt to
open a table after the refresh, I get the "ODBC connect failed" popup. If I
refresh JUST ONE table-link, it works. Then I can open that table. AFTER I
open that ONE refreshed table, *all* tables are now available. However, when
I exit Access and restart, it has forgotten ALL links except the ONE that I
did by itself. When I open that table, it opens fine. Then, once again, all
tables are accessible.
If I close the database (but leave Access running), then re-open that
database, all links continue to work. It's only when I CLOSE Access that it
loses the ODBC connection password. (At least, it appears to be the password
that gets lost.)
I have never seen this issue before. I worked this with an associate, who
believes it's some kind of permissions issue. But I am at a loss to determine
what permission(s) needs to be changed.
When I go in to do a "global refresh" (Select All) of linked Oracle tables,
it *says* it refreshed successfully. (It does prompt me for the database
username and password, which I enter correctly.) However, when I attempt to
open a table after the refresh, I get the "ODBC connect failed" popup. If I
refresh JUST ONE table-link, it works. Then I can open that table. AFTER I
open that ONE refreshed table, *all* tables are now available. However, when
I exit Access and restart, it has forgotten ALL links except the ONE that I
did by itself. When I open that table, it opens fine. Then, once again, all
tables are accessible.
If I close the database (but leave Access running), then re-open that
database, all links continue to work. It's only when I CLOSE Access that it
loses the ODBC connection password. (At least, it appears to be the password
that gets lost.)
I have never seen this issue before. I worked this with an associate, who
believes it's some kind of permissions issue. But I am at a loss to determine
what permission(s) needs to be changed.