[AccessD] Compacting A2K

I've seen this problem on Windows Terminal server systems when the option 
to 'compact on exit' is set on the MS Access database.  The compact works 
fine on stand alone systems but fails on the  Terminal Server 
machine.  This is particularly the case when other users are accessing the 
MS Access file during that time. as well.  I have also found that even if 
the compact works, the permissions on the file is changed so that other 
users cannot access it.  I suspect that Citrix has similar issues since 
Windows TS is supposed to be a subset of Citrix.



Paul M. Jones
Spire Services Ltd.

> >
> >-----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
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com