Can you not take it out of access completely ??

You are always going to have speed issue's with large volumes of data in an Access database, why not try downloading MySQL ?

Its free and and handles large volumes of data far better than access, and should give you faster querying speeds.

In fact i would recommend virtually any other database for large volume data over Access !

If not ...

what indexing have you got on the columns you are querying on ?

Also what query's are you running ?, can you post one or an example ?