amember_access problem..

SELECT a.*, m.login FROM amember_access_log a LEFT JOIN amember_members m USING (member_id) WHERE 1 ORDER BY a.time DESC LIMIT 0,20

I can't view my site because of the error above..

How do I rebuild the table and start again..

I don't want to remove any members..


Thanks
Lee

I also have this what I get from the admin panel..

SELECT COUNT(log_id) FROM amember_access_log WHERE time BETWEEN 20080519000000 AND 20080519235959

when I try to run the query I get the following error..


Table './sunterramuk/amember_access_log' is marked as crashed and should be repaired

Dont worry.. all sorted now.. )