I have a database in MS Access, split on front-end and back-end. There is a whole lot of inserting and updating going on by multiple users. Problem is, my database is bloating (rapidly increasing in size). By rapidly, I mean every hour 100-200 MB increase in size. I closed all DAO objects with which I worked in code which isn't the problem, I think. When I have frontend open only on my computer and I am inserting into database it doesn't grow at all (1500 inserts = 1 MB). I think this has something to do with record level locking but I can not figure out what is the problem really. I turned of row record level locking in my database and .laccdb is still showing, database is still bloating. Also, I am opening all recordsets in dbReadOnly mode.
Do you have any suggestions?