3 Tier Frontend For Ms Access 1

The 3tier FrontEnd for any MS-Access database. Its based entirely on the n-tier technology. One at least application server must be istalled near the MS-Access database. The clients can be installed anywere in the Internet. Firstly the server installation gets all the database schema i.e. tables, fields, indexes, foreign keys and views. After that browsing and editing forms are created. The clients then are setuped automaticaly. In one single pass connects with any of the application servers and copies all the resources (forms, reports, menus). The user, once logged from a remote client has the ability to browse, sort and filter (using composite filtering) all the tables and views of the database. New records of can be added (using edit form) to any table, modified or deleted. The data from any browser can be exported to MS-Excel. One additional tool included in every client, the Remote SQL Executor. The Remote SQL Executor accepts any kind of SQL (select, delete, create, update...etc). The SQL then can be send for execution to the application server and the results are returning. The results can be presented to a browser form or as a report. The SQL queries used can be saved as *.sql files and recalled later for execution. Another important options of the kosmos FrontEnd for MS-Access is the ability to install any number of application servers (n-tire model) against a specific database. Then the clients are connected to any of these application servers.