Post reply

Access SQL Queries Abend closing Access

  • October 24, 2005 at 3:22 am

    #67004

    Hi,

    Access 2000 queries on linked SQL tables bomb out - closing Access with no messages.  Can anuone shed any light on this ?  The query may originally work but when opened later it abends and you cannot go into design view afterwards.

    Thanks to Martin Bastable I can recover the query definition but am stumped as to why it is happening.

    TIA

    Richie

     

  • October 24, 2005 at 6:47 am

    #599450

    Is the query using some access function?

  • October 24, 2005 at 10:40 am

    #599589

    The query was using NZ() function but in an Access Query - was probably the cause.

    I'll be more careful of its use in future - thanks for the pointer.

     

    Richie

  • October 24, 2005 at 11:23 am

    #599605

    Maybe one fo the possible causes... Access will try todo the most work it can on the sql server, but at some point, more than necessary data will be sent back and processed by access. I'm surprised on the no error message part though.

  • October 25, 2005 at 8:45 am

    #599831

    If possible convert your query to a SQL view then link the view to Access.  Views perform better than queries.

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

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