access query taking too much time

[isladogs]

Just to state that I have a single table Access database which is approximately 1.6 GB.
It has almost 3 million UK postcode records and over 40 fields.
However, it is read only so will never grow