Stp Database Administrator Versions History

Version 2.3

New - Optional security. You can disable the internal security, which may be useful if you have installed DBAdmin in a secure folder.
New - Session timeout can be configured from Settings page now. Maximum is 24 hours, which is a limitation of IIS.
New - Allows renaming tables (note, that table creation/modified dates will be changed)
New - Allows viewing of System tables. Read FAQ on the site if you have troubles with this feature (suggested by Ron)
New - Added support for Linked tables (suggested by Ron).
New - Boolean values in record edit form are now represented with checkboxes
New - Added lookup feature for columns that related to other tables
New - Built-in HTML editor for Text and Memo fields.
New - Log-off button added
Update - Find/Filter in table data view has finally replaced with true filter
Update - Paging is now made easier (replaced to combo box)
Bug fix - Unable (or error) to sort by columns that has a multi-word or registered words (submitted by Kevin Bates)
Bug fix - Sometimes Default value got corrupted on the table's structure form
Bug fix - When tryingt to delete a View or Stored Procedure, its name is not displayed on message box prompt
Bug fix - Javascript error when you try to delete a table (submitted by Dominique Boyer)

Version 2.1.1

Bug fix - DBAdmin works properly when ADOX is not available. Note, that not all the features are supported with pure SQL
Bug fix - MSXML version now choosen automatically, version 4 is preferred (checked first)
Bug fix - Error on hosts where MSXML object is unavailable
Bug fix - Some strings were left without translation available.

Version 2.1

New - Default page size (records per page) can be set now in Settings
New - Opens databases from DSN
New - Added feature for importing structure and data from another Access database
New - Jump filter added to the data view and Free-Type Query. You can now specify one-column filter and jump directly to a record matched your criteria
New - Interface's language can be choosen from Settings page
New - Allows changing Locale (Language) of the database.
Updated - Some more properties of database added
Updated - Improved support for multiple languages.
Bug fix - Editing records with multiple primary keys error
Bug fix - On some hosts there was impossible to set default value of the column
Bug fix - Compacting and repairing database could reset its locale language.
Bug fix - If not able to delete a table, was no error reported.
Some minor improvements in the code and usability

Version 2.0.2

Bug fix - Javascript error on Settings page.
Bug fix - Application hangs when trying to view data of a table with no columns
Bug fix - Not able to open a database if folder has no write permissions.
Bug fix - Unable to edit text fields with double quote (") in the data.
Bug fix - Database can be removed from the saved list only when another one is opened
Other minor bug fixes

Version 2.0

Major - The tool was redesigned both in code and look
New - Editing Views and Stored Procedures
New - Free-Type Query can run several SQL statements at once (separated with ";"), also as one transaction and/or ignoring errors
New - Setting/changing/removing database password
New - Editing column names
New column properties for text and memo: Allow zero length, Compress Unicode (new columns only)
New - several settings can be changed through a web-based interface, more will come. Uses XML file for storing
New - shows database file size and how much bytes can be reclaimed by compacting the it
New - database export: select tables, procedures and/or views and DBAdmin will generate an SQL script for them.
Bug fix -Compacting password-protected databases

Version 1.7

Delete table bug fixed
Inserting NULL values bug fixed (submitted by Ivo Vis)
HTTP headers on Windows NT bug fixed (submitted by Ivo Vis)
Multi-language support added
Added No-Cache HTTP header
Password-protected databases support
Cycling Prev/Next while updating or adding records in table (suggested by Christopher Duncan)
Page size in table's data view and Free-Type Query can be changed dynamicaly
Checking for latest version

Version 1.6

Creating new empty databases
Backup and restore database files
Compact and repair MS Access 2000/97 database
NOT NULL field attribute dropped to NULL bug fix
Other minor bugs and improvements

Version 1.5.1

Date/Time field couldn't be created bug fixed (thanx to Mariann D. for letting me know)
Endless loop when database doesn't exists and trying to retrieve tables list (thanx to Raul)
Other minor bug fixes and improvments

Version 1.5

Multiple Primary Keys feature added

Editing data Primary Keys columns (in case it is not an AutoNumber field)

Tables' relationships viewing, creating

Browse for database dialog improved. Now supports browsing on other hard drives and network mapped drives (not tested yet, if you will find a problem with it, let me know)

Builds an SQL statement for creating same table with same indexes (foreign keys are not included)

SQL reserverd words highlighting in Views, Procedures and table statements

XML and MS Excel (.csv) export

Bugs fixes

Version 1.0

Developed and released