Freezing (your post) and crashing (your post title) are 2 different things. Which is it?
If your db is really hovering around 2GB then you have no room left for overhead, in which case I can understand any query causing a problem. If that is the case, either you will have to separate tables into several back ends and link them, or you have outgrown Access and need a version of sql server to hold your data.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.