Results 1 to 4 of 4

Thread: DMAX Issue

  1. #1
    j_jewell
    Guest

    DMAX Issue

    I have an issue I am addressing with an .mdb file. The file runs the query below:

    SELECT Equipment_Local.HDR_ID, Equipment_Local.TimeStamp
    FROM Equipment_Local
    WHERE (((Equipment_Local.TimeStamp)>DMax("TimeStamp","Eq uipment_Local")-1));

    The problem is that the query runs very slow on my local machine (Office 2000, Windows 2000 and SQL 7 back-end), while running extremely fast on another machine (Office 2000, Windows NT and SQL 7 back-end). I have a work-around for this, but I am trying to figure out what the issue is that is creating this discrepancy.

    Anyone know?

  2. #2
    DaveShmave
    Guest

    Re: DMAX Issue

    I am by no means an expert, but I've heard there are issues with Windows 2000, specifically Windows 2000 Server. In fact, some people have reloaded Win NT Server until a fix from Microshaft comes out for Win 2K.

    Have you tried the NT / Windows 2000 forums here? You might find help there but I think you've isolated your problem and it's apparently associated with Win 2K.

    HTH

    Dave

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DMAX Issue

    I haven't really worked with Win2K, but have you tried replacing the DMax with a subquery to see whether that has any impact?

    SELECT Equipment_Local.HDR_ID, Equipment_Local.TimeStamp
    FROM Equipment_Local
    WHERE (Equipment_Local.TimeStamp>(SELECT MAX(L.TimeStamp)-1 FROM Equipment_Local AS L));
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DMAX Issue

    <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    We've been using W2K Server and Win 2000 Professional for months now with absolutely no Access or performance issues. If anything, things appear to run much more smoothly. Far fewer network and hang/crash issues.

Posting Permissions

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