it is a free simple table's browser, for microsoft sql server only for now, it works by connecting to a server, select a database, then all the tables,system tables and stored procedures within the database will be shown in the listbox, just click a table and the content will be put to the grid, default is the first 100 lines will put there, but it can be changed from the options menu. the content put to the grid will be shown fast, because of the virtual bound technique, you can do a search by click the find row menu, all the content match the criteria will be highlighted, right click on the grid to copy the content to the clipboard, other menus are plain and simple just play with it :-D

i've added the ability to create an insert, delete or update script, just like the sql query analyzer does, but i think in better view, because you can select which column to be included, just try by yourself, other is, it ables to browsing tables to see their content or their structural fields/columns, browse system tables, see the views and its script etc.. enjoy!

• browsing tables and views' content by clicking it's name
• see the columns that made a table by a click away
• see the script of the view or stored procedures
• script maker for insert, update and deletion for insert and update you can choose which columns to include in the script created while columns that cannot be null always included
• find row, row that match criterion given will be highlighted and brougt to focus on the grid
• find tables, i got a string, where the heck is it located? you supply information about table's name and column's name, and it will search all tables that have this of column, default, it will search column's name that partially match the search criteria, use "[" or "]" to find a macth column. Or you can supply a content string, so it will search entire database for tables that has column with content match the search criteria, it's very useful for me.
• full view, make the grid fill all form, can be use to comparison utility by open two aespe table browser, chose the table and click the full view option if you set windows to tile the two aespe table browser then you can compare the two content side by side. simple !
• search tables containing column to be wanted or search all tables containing certain text to be wanted
• do backup and restore with ability password protected the backup file.

requirement:

• MDAC 2.7

• Windows Installer (the file to be downloaded is in the .msi format)

• DLL Files - To save bandwidth I have remove these dll files from Instalation
  COMCAT, MSCOMCTL, MSVBVM60, OLEAUT32 and COMDLG32 so be sure that they exists in your system.

any comments/suggestion?

• e-mail me

download :

• download aespe Table Browser
• screenshot of the aespe table browser
• alternate download link

dedicated to :

• to my wife, Teti Hastati! and my sister Yennie Rosyiani Wulansari who introduce her to me
• and from 16-June-2004 for my cute daughter, Tiara Rizka Rabbani :-)

revision :

• from 1.0.265 (17 July 2006)
  - fix restoring backup, target location can be edited even if the target database name not changed
  
• from 1.0.242 (30 June 2006)
  - go to a column by entering exact of it- s column- s name, if you working with table- s with many columns this can be very useful, just right click on the grid to access the menu
  - export to excel, right click on the grid to show it- s menu
  - fix browsing tables that dont belong to current user (but you still need the rights first to that table)
  - simple utility for execute frequently used script up to 20 of them, first select a number then set a script for that number and save, to execute enter that number then play it.
  - use ALT 0 to 9 (0 for script number 10) and CTRL 0 to 9 (0 for script number 20)
  - load n save sql script for query menu
  - multiple form for every time query menu executed and add a font sizer button on that form
  
• from 1.0.231 (17 May 2005)
  - fix some error table's name cannot be copied to clipboard
  - grid will be focused after list clicked, so pressing f5 will refresh the grid's content
  - in query tools, the insert script will offer general script or visual basic's script (automatically format the value for vb programmer like me)
  - more information on table's column view
  - fix handling tables containing letter @, %, ' and %, please let me know if still cause trouble
  - simple backup ms sql server's database with or without password
  - simple restore ms sql server's database with password or not, depends on the backup file when it's created
  
• from 1.0.223 (17 May 2004)
  - add right click menu on grid to set a col's width (select a column first)
  - add copy to clipboard from list's item's name that's selected
  - add deletion to right click when mouse on the grid, deletion also can be done via del button, it will search all content similar to one row selected (the most top if multiple rows selected) then delete them
  - fix refresh when f5 pressed, when on the list then all tables requeried, when on the grid, the table's content will requeried...
  - finally very simple populate table function but i think very useful for testing your queries.., but it wont work on tables that has column type binary, image, varbinary that cannot be inserted with NULL and it wont work on a complex relationship tables, it's very simple
  
• from 1.0.213 (14 May 2004)
  - add timeout entri for connection.
  - add database menu containing, menu to attach, detach and delete database, i think it will be useful for user with MSDE database server
  - add remove, truncate table on right click on the table's list
  - fix autosizing column when viewing table's columns
  - add refresh list's content menu, useful when you drop/delete tables or views using query syntax
  - change about menu.. a litte information about me :-)
  - grid doesn't auto extend last column any more
  - feature see all data within sight, just resize a row, then all columns's width equals = grid's width divided with total columns, so you can read all the data (try resizing one row on employees table on the northwind database, then to fine tune, resize notes' column to see what i mean)
  
• from 1.0.211 (09 Aug 2004)
  - minor fix and change domain to http://www.aespesoft.com/aespe/
  
• from 1.0.210 (25 Jan 2003)
  - add integrated security options, connection wil use login, based on the windows login registered and permissioned in the sql server with authentication type as windows authentication (i have tested with connection from xp to 2k server, but i don't know, it didn't work with w98 to 2kS, Please fill commentary above to give me any suggestion, Thanks in Advance)
  
• from 1.0.203 (23 Jan 2004)
  - add option that can set tabs into spaces
  - defaultly, replace all tabs to 2 spaces, so nicer format for the script of triggers and store procedures
  - add ability that tables can be filtered to be searched in the find table function
  - find table result selected, can be copied to clipboard using right click or ctrl+c
  - searching tables name or columns name can use % added to the searched string
  
• from 1.0.201 (03 Nov 2003)
  -fix mousepointer not becoming pointer when double clickin on the find table result
  
• from 1.0.179 (27 Okt 2003)
  -many searching optimization in sql query
  -add list item search, know the table's name? and lazy to scroll the list? use this!
  -add some error handle when a list item that is not a database object and filter menu clicked will cause error
  -table's name will selected in the list and brought to focus when result from find table form, double clicked
  -form's caption change to table selected when result from find table form, double clicked
  -fix error in the sql query form, when button update/insert/delete clicked but no table is selected
  -tooltip for the listbox show not retrieved for objects (view/systab/sp) that unchecked in the option menu
  -list's tooltip set to empty whenever change database
  -find row menu can search all column containing string to searched if no '=' supplied
  
• from 1.0.173 (25 Okt 2003)
  -in the find table form when esc pressed the form will hide and button renamed to search again
  -still in the find table form, focus will be on the button and mouse pointer become normal when stop pressed
  -some searching optimization
  -add button hide in the find table form
  -change the option menu, now views, system tables and stored procedures can be choose whether to be included or not in the list
  
• from 1.0.167 (25 Okt 2003)
  -add searching progress information in the find table process
  -put a grid into the searching form, so bringing the content of resulting tables easier
  -add progress bar
  -add information about tables being process in the find table form
  -find table form still save the result when the esc button pressed (only hide)
  -when find table executing, the search can be stopped
  
• from 1.0.161( 24 Okt 2003)
  -fix error when colname not entered or other error that might occured
  
• from 1.0.154 (24 Okt 2003)
  -searching tables for certain string not only with column with type text or char can be numeric too
  -status bar tells how many records found
  -fix many small wrong codes
  -double clicking the result will bring the table
  
• from 1.0.143 (23 Okt 2003)
  -add search capability that can find every tables with coloumn containing certain string
  -clear text, list, combobox and grid everytime connect menu clicked
  -add scrollbars in the filtering textbox
  -filtering, col selectioning and create insert update delete script in the sql query menu only able when a table is selected (not views or stored procedures)
  -change the font of the filtering form to courier new
  -put length of stored procedure & trigger script in bytes in the status bar
  
• from 1.0.135 (01 Okt 2003)
  -various fix and optimization
  -copy from grid does not add line feed at the end of the text
  -press F5 will refresh the content
  -last findrow syntax is saved
  -F5 button has many function, execute queries or refresh the grid
  -filter menu will give all coloumns name by the grid's header instead of "*", it may give a wrong connection between the columns for the table selected or columns by result of queries, better execute this only after clicking a table, not after executing a sql query
  
• from 1.0.133 (25 Sept 2003)
  -add mouse hourglass when clicking database
  -fix view trigger script that has more than 4000 chars
• from 1.0.118 (25 Sept 2003)
  -status = stored procedure or view's name in the statusbar when stored procedure clicked
  -show triggers contained in the table to the list
  -show system tables in the database to the list
  -fix some un handle error if the recordset return a no records.
  -show database's view in the list, right click to see it's script
  -add separator between tables - views - system tables and stored procedure
  -no right click menu for triger and stored procedure
  -can copy the grid content using CTRL+C, but must choose which method to use
  
• from 1.0.111 (20 Sept 2003)
  -fix col selection script maker when all column un selected
  -find row can be execute when the grid not empty (not always a table should be selected first)
  -show columns of the table by the order of it's creation
  -include the system tables and stored procedures in the list
  
• from 1.0.110 (19 Sept 2003)
  -include the column's nullable information in the value to be replaced when creating script
  -force field/column that can not be null to be included in the inserting script creation
  
• from 1.0.105 (18 Sept 2003)
  -script maker is better, coz including the column tipe n length for the value to replaced
  -add script in the col selection, so column to be included when generate insert, update script can be selected at will
  -col select n sql query form can be resized or maximized to get the full view
  
• from 1.0.101 (18 Sept 2003)
  -change font in the col selection to courier new
  -add button to create script for insert, update n delete just like the sql query analyzer does
  -add copy, cut, paste for the sql query form and col selection form
  -filtering last syntax saved
  -form col selection, sql query n filter becoming modeless
  
• from 1.0.85 (17 Sept 2003)
  -fix information about table's column's length not correctly shown
  -get rid message box if menu Table's Columns/Table's Content clicked
  -difference between table will show content for column is font becoming bold for coloumn and normal for content
  -quick help menu added
  -exit menu added
  -many minor fix here and there
  
• from 1.0.62 (17 Sept 2003)
  -put hourglass mouse pointer whenever executing a query or accessing the database
  -message box shown to tell that the query is complete executed
  -query menu can be shown without selecting a table first
  -status bar show the correct information about amount of the rows from the query
  -last query syntax is saved, but cleared when exit the application
  -add menu to switch between table's columns or content whenever table is clicked from the listbox

• people find it useful and helpful