...but my method for getting data out of SQLServer is via DTS. We have the server generate Access files on a periodic basis, which can then be attached to by another Access database. We have DTS write to an old version of Access (currently at Access'95, though we stayed on Access 2.x for a long time).

Never have had good experiences with attaching Access to SQLServer. Tends to hog the resources for various reasons.