Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 13th, 2005, 11:25 AM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default is there any auto compact repair utility to buy ?

Hi,
I am looking for a utility that does the auto compact and repair that
works in the background as a service. It should keep logs of the procedure done and should allow database with passwords.
Thanks.
 
Old October 13th, 2005, 11:33 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Surajguru,
Have you checked the compact/repair function help in VBA? You can set it to compact/repair on close. There are compactdatabase and repairdatabase methods in VBA, both for DAO and ADO.

Kevin

dartcoach
 
Old October 13th, 2005, 11:43 AM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Kevin,
Our databases are on the network with domain users login. I need to run the utility as a service during the downtime like late evening or early mornining. I did check the vba code and also Total Visual Agent vendor application. I need a compact-repair application that runs from user login and not as administrator login.
Thanks again for researching and let me know of other products.

 
Old October 13th, 2005, 11:50 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Surajguru,

A question then, do you want to run this when a particular user signs in, or at a specific time, or both? If it's a time setting, you can use the timer event to do it. If it's a user setting, you can do that at that user's sign in, or if it's both, use both.

Kevin

dartcoach
 
Old October 14th, 2005, 06:33 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I take it you have a back end that you want to compact and repair.

You could write a scheduled script that opens and closes the database back end directly at a certain time on your network, and then set up the back end to repair and compact programatically.

That is cheap and easy.

HTH

mmcdonal
 
Old October 15th, 2005, 02:45 PM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I use this for all my clients:

Total Access Agent

Most people do not know that you should only compact a database that is local (on the PC's hard drive). You should avoid compacting a DB across a network. Large databases can be corrupted.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Compact and Repair Access Database raguapk VB How-To 8 May 23rd, 2013 10:00 AM
Automatic Compact and Repair Corey Access VBA 4 March 29th, 2006 10:49 AM
Compact/Repair Access Database On The Fly kevorkian Classic ASP Databases 3 November 22nd, 2004 06:57 PM
Compact And Repair Access Database myedu2k4 Pro VB Databases 1 May 25th, 2004 01:43 AM
Compress and Repair Damaged Database owain Access 4 June 30th, 2003 05:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.