How can I optimize an access mdb file without changing the structure?

Unfortunately I can't change the structure of the database, but how else can I optimise the mdb database?

I've already done the 开发者_运维知识库obvious stuff such as defrag and compacting.

What else can I do?

Is SSD the way forward?

Cheers.

If it is not shared among several users, place the MDB not on a network share but on your local PC, to improve performance. And if you're interested only in querying the database, you can load it into a ramdisk.