[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