[AccessD] Compacting A2K

That's interesting.  I have 1.2 GB where the Windows Temp files go and the
test file I was using was maybe 10 MB.  I have 15 GB on the drive where the
database resides. I'm not sure though how Citrix handles all that.  Thanks
Gary.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gary Kjos
Sent: Wednesday, March 31, 2004 10:02 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Compacting A2K


>>>>"Cannot find field 'Description'".  Error on Compacting A2K<<<<

The times I have had this error it's been because I didn't have enough free
disk space. You need at least twice the available free space as the size of
the oiriginal database. And some of that space si needed on the drive where
the Windows Temp files go.

Gary Kjos
garykjos at hotmail.com





>From: "Gregg" <greggs at msn.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Compacting A2K
>Date: Wed, 31 Mar 2004 07:03:52 -0600
>
>
>
>Oh yeah... sorry.   Office 2K...SP3, Jet... none, NT4...SP6
>
>Thanks John!
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
>Sent: Tuesday, March 30, 2004 9:15 PM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Compacting A2K
>
>
>Office Service packs applied?  Jet SPs applied?  Windows SPs applied?
>
>John W. Colby
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gregg
>Sent: Tuesday, March 30, 2004 10:16 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Compacting A2K
>
>
>I'm really stumped on this one.
>
>I have a 2K database that won't compact.  It says the temporary database is
>in use.  Every once in while it will work... maybe 1 out of 20 tries.  This
>app is running under NT4 and Citrix.
>
>I opened a new database and imported just the tables and got the same
>error.
>I have a mixture of SQL and Access linked tables as well as FE tables.  I
>start removing tables until it begins working but when I add the last
>tables
>I deleted back in, it still works.  It's not consistent.
>
>When it begins to work I start getting another occasional error. At the end
>of the compact process I get an error that says "Cannot find field
>'Description'".  I do have tables with a field name of description but when
>I remove them I still get the error.  The Help says it is error 3799.  I
>can't find anything on it anywhere.
>
>Also, I can move the app to another machine and it will compact fine at
>least until it looks for the SQL links.  We rebuilt Citrix and NT OS which
>did not help.
>
>Gregg Steinbrenner
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee®
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com