SQL access query to count and delete rows > n
I don't have access to a working copy of MS Access to test this but what you might be looking for is this:

delete * from table_name where ID not in(
select top 200 ID from table_name order by id desc
);