INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Butil question

Butil question

(OP)
Hi, I am using NW3.12 with Solomon 2.06 accounting packing which is using Btrieve database. After the application deleted the records, the file (table) did not seem to shrink. I want to use Butil to rebuit the file so that I can claim the usused spaces.
How should I do that? Would the rebuilt file still have the index page during rebuilt?
Thank you.
Gary

RE: Butil question

Are you really that low on disk space?  THe engine will evenutally reuse the space freed by deleting records but does not release it to the OS.  
If you use BUTIL, the indexes will be correct. You will want to make sure everyone is out of the system before rebuilding the data file.  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Butil question

(OP)
Thank you for your reply. Our data files are really big; One of the files is 1.3G; I used MS Access ODBC to check the records and knew that before the deletion, there were >880K records in this file. After the deletion, it only had 230K records. I think it may yeild almost 1G space, if I can rebuilt this file.
Gary

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close