UTE v1.4 - Universal Table Editor

Very welcome to this small demo site of UTE.

There are two ways to connect UTE to a database:

  • Via ODBC, using a so alled DSN connection.
  • Via OLEDB Provider, this means directly to the file, a so called DSN-less connection.

This demo uses the second way, the DSN-less connection. This has two advantages right now: you don't need to setup an ODBC Data Source before you can start exploring UTE, and the second much more important advantage is, that UTE is able to detect PRIMARY KEY fields correctly.

Due to for me unkown reasons there is no working way to detect PRIMARY KEY fields when being connected via ODBC to a database, although there is a specified methode (which simply doesn't do what it should!).

If you want to use an ODBC connection to your database to need to setup an ODBC Data Source and modify the UTE.INC (line 32) accordingly.

Ok, here we start: these are all tables of the TEST.MDB database:


As already mentioned UTE is not able to detect PRIMARY KEYS when being connected to the database via ODBC. In this case you are able to set the PRIMARY KEYS as additional parameters:

Per default UTE sorts all fields in your table alphabetically where all PRIMARY KEYS will be displayed at the most left in italic style. If your don't want UTE to sort the fields you can use the following parameter. In this case you get the fields displayed in the order as they are defined in the database.


That's all for the moment and for this small UTE demonstration. Don't forget to take a look at http://www.codeproject.com/asp/ute.asp for the most recent version of UTE and the latest discussions.

Enjoy UTE !

Tom Wellige, mailto:tom@wellige.com, http://www.wellige.com