Post reply

Using pass through query in Access to SQLServer

  • May 21, 2002 at 10:30 am

    #58201

    How can I make the data I retrieve from a pass through query in Access updateable?

    any ideas?

    thanks in advance

  • May 21, 2002 at 3:40 pm

    #429560

    quote:

    How can I make the data I retrieve from a pass through query in Access updateable?

    any ideas?

    thanks in advance

    You can't directly update the results of a pass-through query in Access. Pass-through queries bypass the Jet database engine and interact directly with the back-end database through the ODBC driver.

    To modify the data you would need to display it in a form and then send each update back via a seperate pass-through query.

    Hope this helps some.

    Phill

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply