We have an experienced development team who work in Delphi, Visual Basic, C# and Crystal Reports. We have a fair number of control libraries and software that we've developed in-house for some of our own projects. We've decided to commercialise some of them and to release them here, on the web, so that you too may benefit from them.

We will be distributing them via various download sites as well, but here is where you will find the most up to date versions of them.

Components and software will be added often, so please check back here regularly. Some will be free. Some will be shareware. In the case of the shareware versions, you can purchase the registered version online, using a credit card. Purchases are done via a secure encrypted connection, so none of your details are visible as they travel across the Internet

Development Tools | Application Software

---

Datasource Name (DSN) Management
During development or installation, how many times have you had to fiddle around in the PC's control panel to set up or remove a DSN? These useful little Delphi and ActiveX components allow you to create and manage Datasource Names for some of the more popular database formats, from directly within your source code. Current DSN/database formats supported are:

• Microsoft Access (ActiveX control also available)
• Text - Within limits, you can treat delimited text files as database files! ActiveX control also available. See also our TextFileParser product.
• Borland Paradox
• XBase - XBase covers a wide range of database file formats, including dBase, FoxPro for DOS, Clipper DOS or other DBase compatible file formats
• Microsoft Excel - Allows you to treat an Excel spreadsheet as a database file (within reason).

---

TextFile Parser
Text File Parser is designed to read, display and help you identify structures within plain vanilla text files. It:

• Opens TEXT (that is plain ASCII) files.
• Displays the contents in a structured, easy to read fashion
• Allows you to define and save the file structure for later use
• Exports the file to a different format.
• Create/modify/delete Text DSN entries directly***
  • (We even bundle the Registered version of the VCL we use to do it.
  • The Time Limited version includes the Freeware version with which you can create the DSN only)
• Test the operation of the Text DSN's so created / modified by using the text files you have examined and saved into Schema.INI***
• Print the structure (or save it in ASCII format to a file)
• Choose your own editor
• Many more features...

Conversions are to:

• Text delimited files (e.g. Tab, Comma, Space, etc.)
• xBase° (as a dBase III database table) - which can be read in Clipper, dBase, FoxPro, etc.)
• Paradox (as Paradox 4)°°
• Excel°
• HTML Table
• SQL Data Definition Statement - CREATE TABLE statement and corresponding INSERT INTO statements
• XML Structure and Records

---

BitByBit
BitByBit translates raw byte code of any file into the equivalent ASCII and HEX characters; and displays them.

Typically these are system and data files developed over years by in-house programmers. Or they may be client files which you have been asked to read and extract the data.

Since you can print the results you can also draw, write, or even doodle over the results without damaging the original code.

All it requires is a file to examine and a text editor to display the results.

New functionality includes Explorer integration and a most recently used file list.

Installation is as simple as extracting the downloaded zip file to a convenient folder. To uninstall the application, simply delete the folder, that's all there is to it!

A help file is included to walk you through using the program.

BitByBit is a free download. The most recent update (v1.2.034) contains an updated help file, the menu strip has been fixed, and context sensitive help should now work properly too.

---

ExploreAccess
ExploreAccess analyses an MS Access database and produces a list of statistics and details on the contents. This can then be exported to a text, XML or MS Excel spreadsheet file, which can be used as an aid to debugging, future development and documentation.

ExploreAccess was written for MS Access 200x. It will examine any earlier version of MS Access once that database has been converted to MS Access 2000 format or later (up to Access 2003). A free demo version is available, with some limitations. Some of the information provided by the freeware version application is listed below:

• Table names
• Field Names
• Query names
• Index Names
• Relationship names
• Macro Names
• Module Names and how many Functions and Sub Routines there are
• Form names
• Report names
• Database statistics - records

Both versions can send the output to a simple ASCII text file. The output is in fixed column format, which makes further analysis much simpler. The shareware version also provides the following information and capabilities:

• Field Names, types, and sizes
• Query names and the number of parameters
• Index Names and their types
• Relationship names (and what is related to what)
• The "Control" queries behind Forms and Reports
• Provides the SQL Statement for each selected Query and/or View
• Provides a Data Definition Statement for each selected Table, Index and/or Relationship
• Displays the contents of selected modules
• Lists the code for selected Macros - when converted to Modules
• Lists the Controls on selected Forms, together with their Properties and (if available) their values
• Lists the Controls on selected Reports, together with their Properties and (if available) their values.
• Lists and allows the translation/exports of any Data Access Pages.
• Export options include normal text format, CSV, XML and into an MS Excel workbook

The shareware also includes the ability to open another Access database without having to close and re-open the application, as well as enabling you to append the extracted information to an existing output file.

For more information download the compressed HTML Help File, ~370kb

---

ExploreExcel
ExploreExcel is a software product designed to make the job of documenting your spreadsheet and helping to correct any errors as simple as possible.

ExploreExcel handles any spreadsheet which Excel can import (created by Gnumeric, Open Office, etc.). Below is a basic list of some of the information provided

• Excel - Version, Add-ins, options, etc.
• Workbook - Author, Worksheets, Charts, etc.
• Worksheets - Name, Extent, Hidden Rows, Protection, Circular References etc.
• Cells - Displayed, Formulae, Conditional Formulae, Array Formulae, Links etc.
• Charts - Names, Dates, Ranges, Chart Types etc.
• Errors - What and where
• Named Ranges
• External Links - From and To
• Comments
• Code Behind - Any VBA code modules and the code, if possible
• Pivot Tables - Name, Location, Source Data, Page and Column Fields etc.
• Scenarios - Name, Location, Changing Cells
• Formula Arrays - Location, Formula, Cells Used
• Functions - What built-in and user functions are used and where
• Objects - Shapes, locations, types.

It provides information about worksheets, cells, links, errors, possible security risks and much, much more!

A free demo version is available, with some limitations.

For more information download the compressed HTML Help File, ~1MB

---

GDataPipe
This useful little application's main purpose is to function as a basic Internet proxy server. If you've ever needed to connect some IP addresses:ports to each other, or browse the web (even securely) without installing bloated proxy programs first, then this is the package for you!

The concept behind it is simple. If you have several PCs on a network (LAN) which is connected to the Internet, in most cases that connection would be made through one PC, which acts as a go-between. All the PCs then need to communicate with the rest of the Internet via this one PC.

Due to popular demand, it also includes a Windows NT/2000 Service version. It also includes an HTTP/HTTPS (SSL) web and secure browsing proxy. Use this for regular web browsing as well as secure access to online resources such as banking.

---

Application Launcher
Having problems keeping user software versions up to date?
This program is designed to simplify your life as a system administrator in an organisation when it comes to distributing new versions of your application across multiple workstations.

If you are not using software such as Application Launcher probably the most commonly asked question by your customer support is "Which version are you using?" And the answer is always the wrong one. How do you keep versions up to date?

 

---