First, I know nothing about Access...does it support triggers?

I believe that you can find a query to check for overlapping ranges in Joe Celko's SQL For Smarties book. This book is one of my favorites. I highly recommend it.

-Mike