Use a different database? Install and use MySQL. It doesn't have any of Access's stupid problems.
And there's a freebie Access-to-MySQL database converter out there. Been years since I used it, but it works quite well.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.