[AccessD] Major Performance Issue!

Hi group,

I've got a MAJOR performance issue. I need to display
a lot of data. A performance test showed that it takes
between 120 - 160 seconds (2 minutes - 2.40 minutes)
to display the data! I have no idea how to speed
things up dramaticly. I really could use some tips.

Here's a description of the current environment:
Access 2000 Client (size: 20 Mb)
Access 2000 Back-end (size: 100 Mb)
approx 4 users
Novel network

Functionality:
I need to display 4 listbox' with data.

Every listbox has the same table as source.
Every listbox has a query as RowSource
Every listbox has this layout:

Proces Type | Date | # Records

Listbox 1 displays 4 records
Listbox 2 displays 2 records
Listbox 3 displays 6 records
Listbox 4 displays 3 records

So the table (tblMultiInterface) has 15 records in
total.

Table tblMultiInterface
Fields:
  Proces Type Text
  Date        Text (!)
  Records     Text (!) (zero records need to display
N/A)

I added the code as an attachment but unfortunatly
this mail was blocked! If anybody would like to take a
look at the code I can send it to you directly.

Comments/tips/etc would be GREATLY appriciated!

TIA
Sad


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus