Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Aug 22 19:44:17 CDT 2005
Binary search? Import half the objects into one database, half into another. Compact and repair both. See which one fails. Eventually you'll find the culprit? But I'd try decompile first on the whole mdb. Then C&R. See if that clears up the problem. Rocky ----- Original Message ----- From: "Arthur Fuller" <artful at rogers.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Monday, August 22, 2005 3:52 PM 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 >