Tuesday, December 02, 2003

Editing Databases

Couple of free tools for editing databases.
  • Office-QB Standard - free download for accessing databases via ADO and ODBC. Basic querying of data, so knowledege of SQL syntax recommended. Office-QB Pro has more features
  • CuteSQL - free download, connects via ADO and ODBC
  • DbaMgr - two versions available. DbaMgr is for SQL Server 7.0 and MSDE 1.0, DbaMgr2k is for SQL Server 2000 and MSDE 2000
  • SQLExecMS - version 1 is free. Can edit MSDE and SQL Server 7.0/2000 databases
  • WinSQL - Lite version free (requires free registration after 30 days). Connects to any ODBC database
  • MySQL Control Centre - edit MySQL databases
Online editing via ASP:
  • 1ClickDB - free (basic editing of data in tables and export from tables and views) and pro (extra features like stored procedures and import) versions available
  • Universal Table Editor - using VBScript class
Set permissions on the folders that you install these to, else anyone with the URL could edit the data.

No comments: