Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 13th, 2005, 11:25 AM
Registered User
 
Join Date: Jul 2005
Location: , , .
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.
Reply With Quote
  #2 (permalink)  
Old October 13th, 2005, 11:33 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
  #3 (permalink)  
Old October 13th, 2005, 11:43 AM
Registered User
 
Join Date: Jul 2005
Location: , , .
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.

Reply With Quote
  #4 (permalink)  
Old October 13th, 2005, 11:50 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
  #5 (permalink)  
Old October 14th, 2005, 06:33 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
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
Reply With Quote
  #6 (permalink)  
Old October 15th, 2005, 02:45 PM
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 12:24 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.