Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Query Runs will not run on a specific computer (Access 2003 SP3)

    This is quite strange, at least to me. I have a query that runs fine on a couple of pc's, but when trying to run it on a third machine the application bombs and restarts Access. All machines are running the same Operating sytem (XP) and the same version of Access (2003 SP3). The query below is the offending query.

    UPDATE tblBaseline SET ImplicitDelete = True
    WHERE Refnum2 In (SELECT sqBaselineDeletes.Refnum FROM sqBaselineDeletes;


    Even when "Viewing" the query in datasheet view it crashes. What should I be looking for to find the root of the problem?

    Thanks in advance for your consideration,

    Ken

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Runs will not run on a specific computer (Access 2003 SP3)

    Does sqBaselineDeletes use custom VBA functions?
    Have you tried Tools | Database Utilities | Compact and Repair Database on the problem PC?

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Query Runs will not run on a specific computer (Access 2003 SP3)

    Compacting one of the back end databases fixed it. Sorry about that. I thought I had already compacted them.

Posting Permissions

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