Arthur Fuller
artful at rogers.com
Mon Aug 22 19:47:46 CDT 2005
All the tables are linked, not resident in the FE itself. But I guess that you are correct, I should import group by group and compact after each. Bummer! Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: August 22, 2005 7:09 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Cannot Compact and Repaid (Access 2003) 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