Copyright
© 1998 GJL Software.
http://freespace.virgin.net/giles.lindsay/GJL-Software/index.html
email: [email protected]
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: [email protected]
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: [email protected]
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.