[AccessD] Schedule Compact and Repair

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu May 29 01:04:24 CDT 2008


So if you are the last user, the ldb file goes away at some point before the
app shuts down?  This works for linked tables to the BE?


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 Doug Murphy
Sent: Wednesday, May 28, 2008 7:18 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Schedule Compact and Repair

Hi Rocky,

One way to do this is to put an invisible form with a timer in your front
end that runs a routine to compact the back end when the front end shuts
down.  You need to have it set so that the routine looks for the back end
ldb file and does the compact if the file does not exist.  Have it test for
the files existence several, maybe 5, and then shut down if the file does
not go away.  If the file is still there it means some one else is in the
database.  When the last person shuts down it will compact.

I have set this up and it works well except for the infrequent crash that
leaves a copy of the ldb.

Doug 

-----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 6:56 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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




More information about the AccessD mailing list