Ms access runtime 2017 compact and repair10/30/2023 If I use my automated VBA script (without compacting) then it crashes halfway through when the database busts the 2Gbyte limit. If I do the process manually (including compacting) then everything works fine and I end up with a 800MByte database. The problem is that a couple of the steps (the UPDATEs) temporarily increase the size of the database which can cause problems with subsequent imports. The process isn't rocket science, but there are several steps so it really does needs to be automated. I have a batch process that I run occasionally, it drops a few old tables, re-imports them from other databases, renames a couple of fields, does a few updates and makes a few other minor changes. I want to be able to run the 'compact and repair' process from within a VBA module in the database.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |