Rob said:
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.