|Thank you so much of replying!|
I was able to do some more research today and learned I had to rebuild the database.
Thankfully it hadn't corrupted so all seems to be working post rebuild.
To anyone reading this with the same problem, I wasn't getting any error messages just wouldn't open even though all other programs would. Def try a rebuild in database utility.
Thank you for looking into this though! Will def come back here for help :-)