Re: ODBC Connection

From: Tim Marshall (TIMMY!_at_antarctic.flowerpots)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 15:56:45 -0330

Rob Oldfield wrote:

> I may be missing something incredibly obvious here.... but why not just set
> up an ODBC connection to your local (I assume) data source?

I think Scott might be referring to something I've wished many times,
ie, when you're isolated for whatever reason from the network on which
your ODBC source resides.

For example, 95% of my Access work has to do with Oracle. Often, on
conferences, when I want to demonstrate how my apps work, I have a
laptop or convention supplied PC that is NOT connected to a local Oracle
database with similar structure to the one I work on or cannot connect
remotely.

In such situations, Personal oracle has been recommended to me, but I've
never bothered with it. Instead, what i do is use a wondrful screen
capture script (I forget the name of it) application in which I do
various things for my presentations and then "play it back" during my
presentations.

As far as "simulating" an ODBC connection in this context - I don't know
how, unless you copy the source to a local jet table and do things that
way. This would not work for me, in my case, because I never use linked
tables against ODBC sources, I use pass through queries. 

-- 
Tim    http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Relevant Pages

  • ODBC setup
    ... I'm trying to setup linked tables through ODBC connection to an Oracle ... I checked my tnsnames entry and used the correct server name, ... tnsnames entry for that particular database, but it is in the format: ...
    (microsoft.public.access.modulesdaovba)
  • mapping cells within same excel sheet
    ... My problem is..I am trying to load a oracle view in the sheet by ... running a database query thru ODBC connection. ...
    (microsoft.public.excel.misc)
  • Re: ODBC Connection
    ... that is what I am referring to. ... Scott ... > I may be missing something incredibly obvious here.... ... >> Is there a way to simulate an ODBC connection on my desktop? ...
    (microsoft.public.access.formscoding)
  • Re: ODBC Connection
    ... that is what I am referring to. ... Scott ... > I may be missing something incredibly obvious here.... ... >> Is there a way to simulate an ODBC connection on my desktop? ...
    (microsoft.public.access.gettingstarted)
  • Re: ODBC Connection
    ... I think Scott might be referring to something I've wished many times, ... 95% of my Access work has to do with Oracle. ... As far as "simulating" an ODBC connection in this context - I don't know ...
    (microsoft.public.access.formscoding)