MS Access and RAM disk?

[OspreyO]

Ok I know this not the way to do things, and it should be on MS SQL, but humor me. I'm just playing with this.

I'm running a MS Access database on a ram disk, on Windows 7 64bit. I've about 1.5MB on the RAM disk out of 4GB total. This in a i3@4Ghz. Being single threaded (MS Access) its mainly using only core, but CPU usage is about 30%, its using only 60% of Physical memory, and its still hitting the HD constantly. Its not paging, so is it a case of no matter what I do MS Access will always use the HD?

As an aside, All my Windows 7 system seem to have constant disk activity even when idle. I've never got to the bottom of that.

 

[OspreyO]

I don't have disk indexing or defragging on.

I thought by having the Access DB on the ram disk, it would have no reason to access the disk at all.

I though the CPU was waiting on the HD thats why it only used 30% of the CPU.