Results 1 to 9 of 9

Thread: [RESOLVED] - Access 2003 indexing problem

Threaded View

  1. Oct 28th, 2009, 10:54 PM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    [RESOLVED] - Access 2003 indexing problem

    we got Access that link to another access and use query...the problem is the
    it got an error that said "exceed more than 2GB temp, ...."

    the query takes so long and it takes more than 2GB temp file when we checked..after several tuning, we know the problem because of indexing in one of the line table that the query takes..after we remove the index..it runs smoothly..

    but, 1 day after..the query stump again and we saw that the index is created again even though we already delete it the day before

    why it happened? any insight?

    thanks,
    erick
    Last edited by erickwidya; Oct 29th, 2009 at 09:21 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width