UTE v3.00 - Universal Table Editor

Very welcome to this small demo site of UTE.

To setup UTE, please copy the contents of the ZIP file (including all subdirectories) to a folder of your choice, create a Virtual Directoty in your IIS that points to it, and launch the index.html (this) page from within this virtual directory.

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. So, you don't need to setup an ODBC datasource first. Due to differences within the ODBC driver and OLEDB Provider implementations UTE is not always able to detect the Primary Keys of your table. If you encounter problems with this just try the other connection method (see UTE Article on CodeProject for more details).

If you want UTE to list all tables of the current database TEST.MDB, just call it without any parameter:

Alternatively you can set the table to be viewed as URL parameter:

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 displays the fields of the table in the order as they have been defined. You can ask UTE to sort them alphabetically using an additional parameter:

That's all for the moment and for this small UTE demonstration. There are two locations to get the latest version of UTE the most recent documentation from and to join discussions about it:

The history of UTE can be found here.

And now: Enjoy UTE !

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