Alternatively you could use the following SQL (works in both 2K and 2005):

select

ts.[Name],

ts.[Score],

ts.[Date]

from dbo.test_scores ts

where...

Try to copy the .mdb file into a Temp directory and then zip it.

I found that with Access you quite often cannot work on the file itself, when it is...

Not in 2005:

You will have to write your own code using Microsoft.SqlServer.Management.Smo .Net library to do it.

If you are interested, I have created a rather raw mockup of such application...