4.1 Login

When you have correctly executed the installation, open the browser and load the page http://www.mysite.com/dbe/default.asp (Or whatever folder you installed it into, and put the name of your domain where the dbe folder is uploaded, instead then www.mysite.com.)
Now you must use the data in config.asp to insert your UserName and Password.
You can choose to remember the login info or to re-enter it every time you use the program by simply checking the box. "Remember me (31 days)". However, after 31 days, you will need to re-enter the username and password again. To stop DBE from remembering the username and password, simply by click on "LogOut" placed at the top-right of the viewer.

4.2 Application structure

In the main page there are two sections:

- explorer:

On the left side of your browser, it shows the list of the directories and the databases of your web site. You can explore the folders or open a database by a click.

- viewer:

This is the main part of the page. When you click on a name of a db (from the explorer), this page will contain the name of the db and the list of its tables.
If you click on a table, the first page in its records will be shown. At the top there will be: the name of the table, the number of its records, the navigation buttons for the records, and in a combo-box, the number of the present page. The number of records in a page is the value you have chosen for the RecEachPage option (in config.asp).
If there are one or more primary keys in the table, there's a key drawn near the field. The value for these fields can't change.
There are for buttons for navigating the table, in order: for going to the first page, back of one page, to the next page and the last page.
You can change the page by a click on the combo-box too, without having to go one page a time.
The records are shown in the same order of the db, but you can order them by any field by clicking on it. The name of this field will turn blue. There's an arrow near this field that describes if the order is ascendant or descendent. If you click on it, the arrow will change, and the order will change too.

4.3 Working with the records of tables and queries (or views)

1) Add a new record:

there's the option "Add a new record" at the head of the table. If you click on this option a new record with edit mode is shown: you can insert the data you want into the db.  To confirm the insert, click on the "V" green button, or click on the "X" red button to cancel the action.

2) Delete a record:

the first column of the table has two small icons: a pencil and a waste basket. Click on the waste basket to delete this record. If the value of the option ConfDel is true a message will pop-up to confirm the delete action; now you can confirm the action and the record will be deleted, or you can cancel the operation, and no change will be done. If ConfDel is false the record will be deleted without confirmation message.

3) Modify a record:

if you click on pencil you can modify this record. All data in the records are now in text boxes where you'll be able to change them. Like the insert operation you can confirm the modify operation or cancel it.

About modifying and inserting a record
When you modify or insert a record that has a counter type field, you must not insert any value; the db will insert a valid value automatically.
If a record has a field where you can't insert a duplicate value, and if you insert a new value and this value is already in the table, the insert operation or modify operation won't to be executed; if you were modifying the record, it will be the same, if you were inserting a new record, no record will be added.
When you execute operations on the records of a view (query) of a database, you can obtain error messages as a consequence of constraints of the queries in relation at the tables from which they are generated. To understand the cause of this possible errors you need to know the structure of the database that you are editing.

4.4 OLE fields

With DataBase Editor it's possible to manage OLE fields as well; fields that can contain files and objects. When a table/query with fields of this type is shown, every cell of every record referred to such field, a button called "MODIFICATION >>" will appear. If you click on this button, you will see a new button: "Sfoglia..."; if you click, it will open a dialog box for the choice of a file on your PC. Once selected, click on the button "UPDATE >>"; the selected file will be uploaded into your database!
When you visualize tables/queries, if the OLE fields contains image files (.gif, .jpg, .bmp), such images will be visible inside the visualization grid of the records of the table/query with other data. They will be shown in a preview format, with a specified width corresponding to the configuration variable OLEImgWidth, and width and height proportionally reduced (or increased). By clicking on the preview, it will open a new window with the image in its wide format.
For corrected visualization of the images contained into the database, it's necessary that they are uploaded with DataBase Editor, and not with Access.

4.5 Multidelete

Not only can you delete one record at a time, DataBase Editor allows you to delete multiple records at the same time as well. To do this you must check the checkboxes of the records that you want to delete and to click the button "DELETE SELECTED RECORDS" which is at the bottom of the table.
Every time you use  "Multidelete," a Message Box will appear, asking you to confirm the deletion of the selected records.

4.6 SQL query

With DataBase Editor it is possible to execute any type of SQL command on your databases: SELECT, JOIN, UPDATE, DELETE, etc., with efficient errors handling, error messages, and ability to correct and re-execute the query.
To execute an SQL query on a database you must write the query inside the input that is at the bottom of the list of tables. Once ready, the query can be executed by click on the button "EXECUTE SQL >>".
Through these commands, you will be able also to modify the structure of your tables directly from the browser (requires a good knowledge of SQL language), so it is good to pay close attention to its use. Also, through the configuration file, it is possible to disable the possibility to execute SQL commands, setting to false the variable AllowSQL.

4.6.1 Wizard to create SQL query

To speed up the SQL query creation and to help non-expert users on this field, from the version 1.4.1, DataBase Editor integrate a wizard to build SQL command.
To run the wizard click on the button "[ SQL WIZARD ]" placed at the top-right on the viewer. It will open a new window. On the top you will see a textarea containing the SQL string at the actual state of its creation; of course, when you open the SQL wizard, the SQL string will be empty.
Just at the bottom there are two button:
- RESET SQL: clear the SQL string that you are creating or that is in memory from the previuous SQL execution;
- RUN SQL >>: execute the SQL command that are on the textarea at the time that you click.

On the second side of the SQL wizard window, there are 4 sections:
- SQL KEYWORDS (1): allow to select the basic SQL commands; at the click, the selected keyword will appear on the textarea;
- SQL KEYWORDS (1): allow to select the basic SQL operators; at the click, the selected keyword will appear on the textarea;
- TABLES: allow to select the names of the tables of the database that you are using; at the click, the name of the selected table will appear on the textarea;
- FIELDS: allow to select the names of the fields of the tables of the database that you are using; at the click, the name of the selected field, referenced from the name of the table wich contain this field, will appear on the textarea.

4.7 Generating Excel reports

An other useful feature is the possibility to export the results of a query, record pages or entire tables into Excel spreadsheet.
To export your data in Excel, you can simply click on the button "EXPORT TO EXCEL >>" that it is positioned at the top of the visualization grid of the records. At this point a window will be open. Now you can chosen what you want to export: 1) the page of records actually showed in the viewer, 2) all the pages of the table or query that it is being visualized, 3) one specified table or view. Choosing the third/fourth option a listbox will be activated; from it you can select the table/view that you want to export.
By click on the "EXPORTS >>" button, it will be start the download of the report the Excel as soon as generated.

You can use DataBaseEditor for all web site on servers which is running one of the following operating systems:

- Windows NT
- Windows2000 with IIS5 installed
- Windows98 with PersonalWebServer installed

The server must support ASP technology And you must have the ability to read/write a db at least in one directory. MSAccess97 and MSAccess2000 are supported.

You must have Internet Explorer 5.0 or higher with cookies and JavaScript enabled.

DataBase Editor has made upgrading easy. Free upgrades or plug-ins, can be downloaded directly from the website http://www.aspcode.it/store/ and then uploaded on your website in the subdirectory "/dbe/update/" or "/dbe/include/" depending on the attached specifications.

The enclosed software is ASPCode.it property and protected by copyright.

Rights and laws about the license:

what you can:

- you can use a copy of the licensed software on one or more internet sites.
- you can connect and use the application present on the internet site/sites, from every location, fixed or mobile.

what you can not:

- you can't let sub-licenses, sell, rent a part or the full license.
- you can't modify, decompile, disassembly or translate the software, you can't do any thing to get the original code.
- you can't add a part or the full program, to other commercial application.

If the customer has used an on-line demo, trial version, or registered version of this software; we are in no way responsible for data loss or other damages caused by the use of this application.

All sales are final and refunds are not possible, because fully a functioning version of this software is available for testing before you purchase it.

Other distribution or sale of the enclosed software to this license, without the explicit permission by ASPCode.it is absolutely forbidden and will be pursued to the maximum extent of the law.

You can install and use the program or every previous version on one or more internet site.

The license buyer can make a security copy of the software.

ASPCode.it is not responsible for any incidental damage, direct or not direct, or consequential (included damages of profit loss, interruption of the work activity, lost information or any other loss) caused by use or not use of the software, even if caused by the support service.

Any damages are limited to the cost of this software.

A particular thanks to:

- Marco Sinigaglia (co-worker in ASPCode.it)
- Giacomo Graziosi (technical support)
- Keith Cleversley (translation to english language)
- Fausto Nenci (testing and debugging)
- Stefano Ricca (testing and debugging)

For every necessity, question, recommendation, contact us at this E-Mail address; we are happy to help:
store@aspcode.it