MS Access Stops and Compact and Repair Fails
Posted on 2012-03-22
I'm having a frustrating problems with MS Access. The programs stop in the middle of a relatively simple process. When I try to compact and repair the database, the mySysCompactError table has records like:
-1907 You do not have the necessary permissions to use the 'MSysAccessStorage' object. Have your system administrator or the person who created this object establish the appropriate permissions for you. MSysAccessStorage
I'm using MS Access 2003, and Windows 7.
My database starts out at 112,068 KB. I have a table with 180,000 records with a Full Name field. I am spliting it into First Name, Last Name, etc. If I only process a 2000 records, everything works fine. If I try to process all the records, the program stops in the middle and the file size grows to 810,848 KB. I can open the database, but when I try to work with the table, Access quits again. If I try to Compact and Repair, the process fails.