I already have Office Home & Student 2007 which does not included Access. I am trying to find somewhere to puchase it and can only find one obscure website. I have tried Ebay, Amazon and various other sites to no avail.
I can't think of a reason why it shouldn't be compatible - what makes you say that?
It would be interesting to know what you need Access for. Is it to open existing Access Databases or to create new one's? Have you tried LibreOffice which is an open source (Free) Office Suite that is compatible with Microsoft XML formats (2007-2010 Office files)