[AccessD] Schedule Compact and Repair

Lambert:

The problem in this case is not backup but compacting.  The user ran into a
problem running the app and found that the problem went away after a
compact.  So now he wants to be able to do the compact automatically.  The
problem of course is that everyone has to be out of the mdb to do the
compact.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Wednesday, May 28, 2008 2:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Schedule Compact and Repair

The disadvantage of using the windows scheduler in today's "locked down"
computer world are that you need admin rights to run it and you have to
remember to change the password of the task when the user is required to
change it by company policy. 

A disadvantage of having the app do it itself via a timer form is that the
app must be running somewhere at all times, and that makes it more difficult
to update the app (perhaps).

For myself, I use a little backup program called Backup4All. It has its own
built in scheduler so backups happen when desired, but it also has the
ability to run other tasks before and/or after a backup job runs. I use that
feature to run a batch file that does the compacting prior to the backup -
at 3 AM. It then runs one final task after backing up - it powers off my
computer.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, May 28, 2008 3:22 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Schedule Compact and Repair

Dear List:
 
A regular compact and repair of a back end needs to be schedule.  Windows
Scheduler would do nicely I'm sure running a small app that would C&R a
specific back end.  Problem of course is getting all the users kicked out.  
 
I know I have seen threads on this in the past but little no attention, of
course, because I didn't have the need at the time.
 
Is there a canned solution for this - on our site or one of the other Access
sites? 
 
MTIA,
 
Rocky
 


 	
	
 
--
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

No virus found in this incoming message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 269.24.1/1470 - Release Date: 28/5/2008
07:20