How to solve the problem of inconvenient website construction and maintenance using Access Database

Access is used as the site-building Database. In addition to the low cost, Access database is prone to deployment. An MDB file contains all the tables and data, after the development, you can upload it to the website together with the web page and ASP script, and there are also a lot of development tools. In addition to Office, there are also many third-party tools available.
However, it is inconvenient to use the Access database. Once the MDB file is uploaded to the website, it is not very easy to operate. The above tools are like "hitting the bull in the mountains" and cannot be used at all, the usual practice is to download the MDB file to the local through FTP, and then return it back to the website after the operation. If the database is read-only to the website user, it is okay, if a website user writes information to the database, it will be troublesome.
The internet database browser can solve the above problem. This software installs an ASP or ASP on the website. NET script, and then locally install the internet database browser can achieve online Access database on the site online operations, software interface type MS-SQL query analyzer, but also can change the table content, it is also an online database Document Manager. The simple operation steps are as follows:
1. Use the script deployment wizard of the internet database browser or manually upload the webdb. asp or webdb. aspx script included with the software to the website;
2. Install the internet database browser locally;
3. Select "New Database Connection" and fill in the URL of the script uploaded to the website in the script URL field, for example, http://www.mysite.com/asp/webdb.aspx. then select the driver. The script URL is webdb. select "[asp] Microsoft Access Driver (*. mdb) ", dbq fill in the MDB file relative to webdb. asp URL or absolute path of MDB file, such .. /mdb/mydb. mdb,/mdb/mydb. mdb, C: Inetpubwwwrootmdbmydb. mdb; the script URL is webdb. select "[ASP. NET] Microsoft Jet 4.0 ole db Provider ", the Data Source is entered in the same way as dbq;
4. Click the new connection and enter the password (if any.