Results 1 to 6 of 6

Thread: ACCESS: Newbie confusion - db/table vs. workspace/connect/recordset [RESOLVED]

Threaded View

  1. Jul 18th, 2005, 01:37 PM #1
    Webtest
    Webtest is offline

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved ACCESS: Newbie confusion - db/table vs. workspace/connect/recordset [RESOLVED]

    Esteemed Forum Participants and Lurkers:
    ===============================
    MS ACCESS, remote Oracle Database Newbie Alert!

    I have an assignment to fetch a snapshot of some date limited data using MS Access from a large corporate Oracle database for a set of reports. I can now comfortably fetch data using ODBC static Pass-Through Queries. I need to generate my queries programatically, though, and I am quite confused, and I have virtually no reference information ...

    Do "Database"/"Table" go together as "Workspace"/"Connection"/"Recordset" go together? (am I even close?)

    What determines when I would use a Database/Table, as opposed to when I would use Workspace/Connection/Recordset?

    Is there some template code somewhere that I can use as a tutorial for learning the basic processes of fetching data from a remote database?

    Thank you for any and all comments, suggestions, and assistance.
    Last edited by Webtest; Jul 22nd, 2005 at 11:52 AM. Reason: Title Clarification
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width