Database management grid with record edit, delete, add, search, filter and export to excel, database and table dropdown selection, pages navigation, field sort and search in page.
This application fills a sortable, pageable html table with records from a database.
Features: database and table selection, records edit, delete, add, export, filter and search.
Now working with MS Access, MSSQL and MySQL databases.
REVISION HISTORY:
V 8.1: (thanks to users suggestions)
-- fixed "800a0bcd" error when trying to add a new record to an empty table
-- fixed wrong LCID date format, MM/DD/YYYY - DD/MM/YYYY
-- added replacement statement for
to VbCrLf in the grid memo fields
-- added checkboxes toggle selection to show/hide unwanted columns name and content
-- added checkbox toggle selection to show field description insthead of field name (Access only)
-- added procedure access control with password protection system
(Username=admin, Password=pass)
-- added report print feature for all filtered records
-- added single record report print feature
-- added database compact utility (Access only)
-- added toggle display of field type in the add/edit window
-- changed user input SQL query command layout
-- some minor bugs fixed