Create a new access database, then use the table linking option to link to the one that won't "open". Transfer your data over to your new, uncorrupt database that way.
Dude, July 2007
You can get a repair tool for Access Databases from here http://support.microsoft.com/support/kb/articles/Q273/9/56.asp