[AccessD] Cannot Compact and Repaid (Access 2003)

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
> 




More information about the AccessD mailing list