Tools CastellanTools Banner
Free       Updated

Castellan Tools is a free download for you to enjoy. Yes, we did say free; We'll charge you nothing. We found them useful and thought we could make then available to others. We have used similar free tools from other developers and they have saved us a lot of work. For which we're very grateful.

Castellan Tools comprises 10 distinct tools that help the Microsoft Access developer with their builds.

Over time we have either developed some utilities, found other free utilities out there and enhanced them or built front-ends for code that was freely available; the result is that we compiled a group of utilities that assists us with any Microsoft Access development.

We found them useful and they fill some of the gaps in Microsoft Access’ functionality; so, thought we could make then available to others. We have used similar free tools from other developers and they have saved us a lot of work. For which we're very grateful.

CastellanTools Window

CastellanTools Window

Remove DSN Links / Relink Database is a simple tool that allows you to convert your linked database tables, in an Microsoft Access database, to DSN-less connections. It also allows you to relink all tables to the SQL Server Database; or if required, to the same database on another SQL Server instance.

SLQ to VBA is a simple tool that allows you to convert SQL to the corresponding VBA code that can simply be copied and pasted into your code.

You can either enter the SQL code manually or select a query from an existing Microsoft Access database.

CastellanTools Window

CastellanTools Window

Access Database Health Check is a tool that reports on potential issues with the structure of Access databases. It makes no changes to the databases you examine. The tool is intended for developers to check their application during design, and consultants who examine others' databases.

Database SQL Generator is a tool that will take as input a Microsoft Access database and generate the SQL code required to create it as a SQL Server database. It can also create the SQL Server database for you. In other words, it fills in the gap in Microsoft Access where you can only migrate one table at a time and it doesn’t migrate the table's keys, indexes or relationships.

CastellanTools Window

CastellanTools Window

Data Dictionary allows you to view a database’s data dictionary and make some basic database modifications. The tool allows you to:

  • View Data Dictionary for selected table.
  • Go to Table Design view of selected table.
  • Open the Datasheet View of selected table.
  • Rename selected table.
  • See if there are text or memo fields where Unicode Compression is not set.
  • See an estimate of record width (sum of the data type sizes, taking compression into account).
  • Change Display Control of selected fields.

Set Database Properties is a tool that is used to set the database properties that aren't easily managed from the Access user interface. These properties can be set easily enough from the Access user interface (Tools/Startup), but once set, certain combinations won't allow you back into the Startup menu.

CastellanTools Window

CastellanTools Window

Unicode Character Map is a tool that is used to view and select the many Unicode characters available. The grid shows 200 Unicode characters in 10 rows and 20 columns.

Colour Calculator is a simple tool that allows you to convert RGB colour codes to Hex and CMYK codes and vice se versa.

CastellanTools Window

CastellanTools Window

Ribbon Assistant is a tool that helps you build ribbons for your Access applications with your own icons.

Base64 Encode/Decode is a simple tool that does exactly what it says; decodes Base64 encoding and encodes into it quickly and easily. Base64 encode your data in a hassle-free way, or decode it into human-readable format.

CastellanTools Window




Go to the Download page to get it.