Gentlegeeks:
Access 2000-2003 type 2007 db, inherited. This animal calls upon Oracle tables in various ways -- ADODB recordsets, Access queries, Pass through queries...I think that's it.
Among the things I'm working around is intermittent requests for ODBC credentials, which is a problem if the thing runs in the middle of the night, as it does.
So being of a coding mind, my approach is to attemtpt to isolate and control the connection. If the linked tables need to be refreshed, OK, fine, I've found some nice code out there. In other spots, I have pass-through queries with programatically set connections strings. Some of the original code opens an ADODB recordset...and my preference is DAO.
One thing I noticed is that, if I refresh the table links prior to the ADODB recordset attemtpt to query a linked table, an error arises stating "you can't use this connection for this operation" or some such.
Now my first reaction to something like this is that there's too much going on in the way of connections here, and things need to be reigned-in a little bit. Actually, I'd like to adopt a standard approach and use it throughout.
It's not so much that I need to know which way is "best" in anyone's opinion, but I need to know what each is like in plain english -- and what the differences are in methodology and protocol. Just a survey will help me begin to get my head around the situation so that I can begin to make The Grand Plan on how to go about this. Maybe I need all three methods...I sorta doubt it, but who knows?
Can someone begin to describe the lay of the connection land a bit for me?
thx