Database Utilities 1.3

Copyright 1998 GJL Software.

http://freespace.virgin.net/giles.lindsay/GJL-Software/index.html

email: gjl.software@virgin.net

This application is 'SHAREWARE'.


Introduction:

Database Utilities is an enhanced MDI Database Desktop Utility, with features provided to speed up database access and manipulation, BDE configuration and BDE management, plus many other tools. It is an excellent and powerfull tool for database and delphi developers alike especially those using the BDE.

Version 1.3 has been developed on version 1.2 with plenty of new features for database development improved interface with Office 97 style toolbars, full database alias functionality and bug fixes discovered in version 1.2!

System Requirements:

486 or Pentium Processor
Windows 95 / 98 / NT
32-Bit BDE (Downloadable free from
Inprise's Homepage)

Viewing Recommendations:

Hi-Res Colours
Small Fonts
Minimum Resolution - 800x600
Recommeded Resolution - 1024x768 or higher

Description Of Features:

1. 'Database Structures':
This is a utility that encapsulates the viewing of all dBASE, Paradox or MS Access tables (
new in version 1.3) in a given directory or Alias in a list on the left of the form, for quick access, to show and be able to manipulate the data in the selected table.
You can also view full information listings of all the fields and indexes of that table, the family files of that table as well as being able to view and print the database structures in full report format, quick view format the actual data in the database (
with new features in version 1.3) and the Delphi source code of the given table.
Full SQL querying is now featured in the application (
new in version 1.3), including printing the SQL query and the query result set.
A feature of this program (which does not exist in Borland's DBD) is the viewing of any blob field (for both dBASE or Paradox tables) in the dataset by double clicking on the glyph in the data grid. You can even save the data out as a text file or as bitmap images or even import your own text files or bitmap images in the table.
Right mouse clicking on a selected table in the left column brings up a given set of tools for manipulating the actual table you are working on.
These features are:
- Packing the selected table a lot faster than DBD (without reversing the indexes);
- Emptying the selected table a lot faster than DBD (without reversing the indexes);
- Adding or Deleting an Index on the table;
- Adding or Deleting a Field on the table; (
new in version 1.3)
- Reindexing a corrupted table;
- Reversing Indexes corrupted by using other programs written in Delphi;
- Renaming the table;
- Converting dBASE tables to Paradox and other dBASE tables with data and indexes, and vice versa; (
new in version 1.3)
- Unlocking locked tables;
- Deleting tables;
- Version Changing Paradox tables from one version to another;
- Viewing the actual database language of a given table. (
new in version 1.3)
This utility is highly useful when you need to compare two or more large database directories, by opening two or more 'Database Structures' windows for particular directories and never having to open a new window for each table.

2. 'Database Packer':
This is a utility that allows the user to quickly pack either one or more tables of both dBASE and Paradox types in a given directory or Alias extemely quickly, without the problem of reversing indexes.

3. 'Database Empty Table':
This is a utility that allows the user to quickly empty either one or more tables of both dBASE and Paradox types in a given directory or Alias extemely quickly, without the problem of reversing indexes.

4. 'Database Language Changer':
This is a utility that allows the user to quickly change the table language of either one or more tables of both dBASE and Paradox types in a given directory or Alias extemely quickly, without the overhead of using DBD on single tables at a time. (
new in version 1.3)

5. 'Repair and Compact Access Tables':
This is a utility that allows the user to quickly repair and compact, just repair or just compact one or more MS Access tables in a given directory or Alias extemely quickly. (
new in version 1.3)

6. 'Database Converter':
This is a utility that allows the user to convert dBASE tables to Paradox and other dBASE tables with data and indexes, and vice versa. (
with new features in version 1.3)

7. 'BDE Configuration Manager':
This is a utility that allows the user to edit or create the BDE Idapi32.Cfg File, without having to use a different program to do it. Using this utility you can also test the access to a particular Alias to see if the connection still exists as well as creating and testing the connectivity of InterBase databases. (
with new features in version 1.3)

8. 'BDE Properties':
This is a utility that allows the user to view all the BDE settings in a quick format as well as all the version stamps of the BDE files. It also shows:
- What Aliases exist;
- All BDE Driver Names;
- All BDE Language Drivers;
- All BDE Repositories;
- All BDE Users accessing specific data.

9. 'BDE Alias Manager':
This is a utility that allows the user to create, edit or delete Aliases part of the BDE.

10. 'Create New dBASE Table':
This is a utility that allows the user to create dBASE tables and also allows creation of expression indexes as well as normal indexes.

11. 'Create New Paradox Table':
This is a utility that allows the user to create Paradox tables.


Disclaimer, Warranty and Licence:
No warranties expressed or implied. I am not responsible for any problems that might arise from the use of this program. You use this program entirely at your own risk. The trial program can be freely used and distributed in commercial and private environments, provided that this notice is not modified in any way, without my expressed written consent and that the program is registered by each new owner.


Database Utilities Normal Registration Information

(See Below For Information For Users Upgrading From Version 1.2)

Registration fee: $59,99

If you would like to register Database Utilities, you can do the registration online on
the Internet at
http://www.shareit.com/programs/101786.htm. Alternatively, you can
go to
http://www.shareit.com and enter the program number there: 101786.

If you do not have access to the Internet, you can register via phone, fax or
postal mail. Please cut and paste and then print out the following form, and fax or mail it to:

ShareIt! - Reimold&Schumann Internet Services
Habsburgerring 3
50674 Koeln
Germany

Phone: +49-221-2407279
Fax: +49-221-2407278
E-Mail: register@shareit.com

US customers may also order by calling 1-800-903-4152 (orders only please!). US check and
cash orders can be sent to our US office at

ShareIt! Inc.
P.O. Box 97841
Pittsburgh, PA 15227-0241
USA



Registration form for Database Utilities
=========================

Program No.: 101786

Last name: ___________________________________

First name: ____________________________________

Company: ____________________________________

Street and #: ______________________________________

City, State, postal code: ________________________________

Country: _______________________________________

Phone: _____________________________________

Fax: ________________________________________

E-Mail: ______________________________________


How would like to receive the registration key/full version?

e-mail - fax - postal mail


How would you like to pay the registration fee of $59,99:

credit card - wire transfer - EuroCheque - cash


Credit card information (if applicable)

Credit card: Visa - Eurocard/Mastercard - American Express - Diners Club

Card holder: ________________________________

Card No.: ___________________________________

Date of Expiration : ___________________________________



Date / Signature ___________________________

------------------------------------------------------------------------------




Database Utilities Upgrade Registration Information

Registration fee: $39,99

If you would like to register Database Utilities, you can do the registration online on
the Internet at
http://www.shareit.com/programs/101788.htm. Alternatively, you can
go to
http://www.shareit.com and enter the program number there: 101788.

If you do not have access to the Internet, you can register via phone, fax or
postal mail. Please cut and paste and then print out the following form, and fax or mail it to:

ShareIt! - Reimold&Schumann Internet Services
Habsburgerring 3
50674 Koeln
Germany

Phone: +49-221-2407279
Fax: +49-221-2407278
E-Mail: register@shareit.com

US customers may also order by calling 1-800-903-4152 (orders only please!). US check and
cash orders can be sent to our US office at

ShareIt! Inc.
P.O. Box 97841
Pittsburgh, PA 15227-0241
USA



Registration form for Database Utilities
=========================

Program No.: 101788

Last name: ___________________________________

First name: ____________________________________

Company: ____________________________________

Street and #: ______________________________________

City, State, postal code: ________________________________

Country: _______________________________________

Phone: _____________________________________

Fax: ________________________________________

E-Mail: ______________________________________


How would like to receive the registration key/full version?

e-mail - fax - postal mail


How would you like to pay the registration fee of $39,99:

credit card - wire transfer - EuroCheque - cash


Credit card information (if applicable)

Credit card: Visa - Eurocard/Mastercard - American Express - Diners Club

Card holder: ________________________________

Card No.: ___________________________________

Date of Expiration : ___________________________________



Date / Signature ___________________________

------------------------------------------------------------------------------


Future Development:
I hope to be able to include in the next major release of Database Utilities:

1. Extra Table Restucturing (dBASE, Paradox and MS Access);
2. MS SQL Server Access Hopefully To Be Included.
3. Utilities To Fix Corrupted dBASE And Paradox Tables.
4.
Options For Scheduling And Automatic Execution Of The Utilities Through A Batch String Of Commands.

If you have any comments about the program, or you have found some bugs, or perhaps you may have some ideas on improving the program then please email me (just click on my email or URL link on the 'About Box' to launch your default email program or browser).

Copyright 1998 Giles Lindsay - July 1998.



MS-ACCESS Accessability:

Q: How do I access MS-ACCESS tables in Database Utilities 1.3?

A: You need the following ODBC files.

Minimum:
ODBC.DLL 03.10.1994, Version 2.00.1510
ODBCINST.DLL 03.10.1994, Version 2.00.1510
ODBCINST.HLP 11.08.1993
ODBCADM.EXE 11.08.1993, Version 1.02.3129

Better:
ODBC.DLL 12.07.1994, Version 2.10.2401
ODBCINST.DLL 12.07.1994, Version 2.10.2401
ODBCINST.HLP 12.07.1994
ODBCADM.EXE 12.07.1994, Version 2.10.2309

The following steps will get you started:

1. Using the ODBC Administrator, set-up a datasource for your database. Be sure to specify a path to your mdb file. For the purposes of this explanation we'll say that the datasource name is MYDSN.

2. Load the BDE Configuration utility.

3. Select New Driver.

4. Give the driver a name (call it ODBC_MYDSN).

5. In the driver combo box select, "Microsoft Access Driver (*.mdb)

6. In the name combo box select MYDSN

7. Go to the Alias page.

8. Select New Alias.

9. Enter MYDSN for name.

10. For Alias Type, select ODBC_MYDSN.

11. Save BDE Configuration.

12. In Database Utilities, select Database Structures and select the newly created Alias on the open table dialog.

13. You will then see the "Login" dialog. Press OK, after a short pause you will see a list with all your table names. Select one.

16. Your table will then be displayed in the Database Structures Utility.