Access 2000 Database Convertor

I needed to convert several Access Database to conform to the PostgreSQL definition for TablesNames and FieldNames, for this purpose i made this application that does most of it automatically. It converts the Tables, Queries, Forms, Reports and Modules in Multiple Access Applications. Afterward you can Use the PGAdmin Migration Wizard to move the Databse part to PostgreSQL.

I see that more people had problems with this. Maybe they can use this util.

Application Description: Access 2000 Converter 0.99

This application will convert your Access Databases and Access FrontEnd Application to conform to the PostgreSQL Requirements. Postgresql will only allow for TableNames and FieldNames that are less than 31 Characters and Can not contain any spaces or special characters (Like "!@#$%^&*()).

The Access 2000 Convertor will rename all TablesNames, FieldNames, Indexes in your Master Database. It will also Update any links to these Tables and FieldNames in your Queries, Forms, Reports, and Modules. At this moment Macro's will not be updated (still haven't found that one out.

You will have to use DBTools to convert the MasterDatabase to PostgreSQL.

After conversion your can automatically update all the links in your FrontEnd Databases to the New MasterDB or A Database in PostgreSQL (Converted with DBTools).

It is release under GPL.

Talon 2003 http://www.talon.nl

Download