Dan Waters
dwaters at usinternet.com
Mon Aug 22 18:08:44 CDT 2005
Arthur, Import each group of objects separately. Test after each import. I'd try tables first since nothing else compacts. Then import say, 10 of each object to narrow down to the offending single object. HTH, Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, August 22, 2005 3:53 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Cannot Compact and Repaid (Access 2003) I have an app that reports ``Invalid operation` when I attempt to compact and repair. I already tried creating a new one and importing everything, and I get the same error on the new one. I can however successfully compile the app. I am puzzled. There are lots of forms, queries, reports and modules, so I really do not want to import them one by one to see where the problem lies. Any other suggestions? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com