2 comments.
1. Try the vista driver at http://www.adaptec.com/en-US/downloads/ms/ms_win_vista?productId=AHA-2940UW&dn=AHA-2940UW
Note there is a contact link to ask them if there will be such a driver.
2. I find many times these work but only AFTER I install the motherboard drivers. I lost count how many times that helped.
Remember that Adaptec is the source for this one. Posting all over and not going to the source will only frustrate you.
Bob
I am running Windows 7 Ultimate 64Bit and i need a driver that will work with and Adaptec AHA-2940UW or and Adaptec AHA-2944W. Does anybody know of any out there that will work. I need it for my tape backup drive.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic