In addition to the low cost reason, the use of Access as the website building database is mainly due to the ease of publishing of the Access database. An MDB file includes all tables and data. After development, it can be uploaded to the website together with web pages and ASP scripts. There are also many development tools. In addition to Office, there are many third-party tools to use.
However, there are also inconveniences when using the Access database. Once the MDB file is uploaded to the website, it is not easy to operate. The above tools are like "fighting a cow from a mountain", which is completely useless. The usual practice is to download the MDB file locally through FTP, and then upload it back to the website after the operation is completed. If the database is read-only to the website users, it will be troublesome if the website users can write information to the database.
Using an Internet database browser can solve the above problems. This software can install an ASP or ASP.NET script on the website and then install an Internet database browser locally to operate the Access database online online. The software interface type MS-SQL query analyzer, but it can also change the content of the table. It is also an online database document manager. The simple operation steps are as follows:
1. Upload the script webdb.asp or webdb.aspx included with the software to the website through the script deployment wizard of the Internet database browser or manually;
2. Install the Internet database browser locally;
3. Select "New Database Connection", fill in the URL of the script uploaded to the website in the script URL domain, such as: http://www.mysite.com/asp/webdb.aspx, and then select the driver. The script URL is webdb.asp. Select "[ASP]Microsoft Access Driver (*.mdb)". Dbq fills the URL of the MDB file relative to webdb.asp or the absolute path of the MDB file, such as ../mdb/mydb.mdb, /mdb/mydb.mdb, C:/Inetpub/wwwroot/mdb/mydb.mdb; Select "[ASP.NET]Microsoft Jet 4.0 OLE DB Provider”, the filling method of Data Source is the same as that of dbq;
4. Click on the newly created connection and enter the password (if any).
Software download website:
Official website
http://www.greatenengine.com/DownLoad
Huajun Software Park
http://yncnc.onlinedown.net/soft/29697.htm
Sky Software Station
http://www3.skycn.com/soft/17099.html
NetEase
http://dl.163.com/html/53/53403.html
ZD Net China
http://www.zdnet.com.cn/download/windows/swinfo/0,2008005031,39176140s,00.htm