Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Open a second instance of MS Access 2000 .adp file from within my .mdb file

Discussion in 'Information Technology' started by wb, Oct 27, 2005.

  1. wb

    wb
    Expand Collapse
    Guest

    Yes, I am connecting via linked tables. I have never worked with
    pass-through queries....I will look into that, thanks!
    It would be great if that would work because it seems strange that I have to
    use an .adp to get some data, and the .mdb for the rest.

    thanks for following the tread.

    wb

    "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
    news:egpt5la2FHA.3876@TK2MSFTNGP09.phx.gbl...
    > "WB" <none> wrote in message news:ONB9Lha2FHA.744@TK2MSFTNGP10.phx.gbl
    >> "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
    >> news:er2O1ZZ2FHA.3788@tk2msftngp13.phx.gbl...
    >>> "WB" <none> wrote in message
    >>> news:e0tPIyY2FHA.896@TK2MSFTNGP09.phx.gbl
    >>>> I have an .mdb file that resolves 99% of the users reporting needs.
    >>>> However, the limitations within the .mdb prevent a couple of reports
    >>>> from running because of the complexity built into the queries.
    >>>> Through various posts within the newsgroups the workaround was to
    >>>> use .adp file for the few reports needed.
    >>>
    >>> I'm curious as to what circumstances required the use of an external
    >>> ADP.

    >>
    >> If you search for the following thread (System not Responding when
    >> query is executed) within the access.queries group that should give
    >> an example.

    >
    > If you're connecting to SQL Server via linked tables, did you consider
    > running the query as a pass-through query (after revising it to conform
    > to T-SQL syntax, of course)?
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
     
  2. Loading...


Share This Page