I am unable to successfully compact/repair my Access 2007 accdb. The file is fairly large but well below the 2gb limit. This seems to have just started. I have a nightly script that compact/repairs several accdb files. This script ran fine for 12-16 months. Now it seems to fail for all accdbs.
I tried manually compactiong with the same failure. I tried creating new accdb and importing the table, no help. I validated all my indexs, no help. These accdb are just the backend data, contains only table objects.
What I found recently, if I copy the accdb to my local drive, compact/repair runs fine. The source accdbs are all still functional, I just can not compact them. As we know, Access seems to bloat without compacting regularly.
I am concerned my files will reach the 2gb limit if I can not get this resolved. Any help would be appreciated.