How to solve the problem of using Access database to build a station to maintain inconvenient problems-application techniques

Choose Access as the database for the build station, in addition to the low-cost reasons, mainly the ease of publication of Access databases, an MDB file includes all the tables and data, developed with Web pages and ASP scripts uploaded to the Web site on it, there are many development tools, in addition to Office, There are also a number of third-party tools that can be used.

But there are also places where it is inconvenient to use an Access database, once the MDB file uploaded to the site, it is not very good operation, the above tools like "ge dozen Cows", completely not in use, the usual practice is to download the MDB file through FTP to the local, the operation is completed and then uploaded back to the site, It is not a problem if the database is read-only to the site's users, and if the site user writes the information to the database, it will be troublesome.

Using the Internet Database browser can solve this problem, the software by installing an ASP or ASP.net script on the website, and then installing the Internet Database browser locally, it can realize online operation of Access database on the website, software interface type Ms-sql Query Analyzer, However, you can also change the contents of a table, as well as an online database document manager, with the following simple steps:

1, through the Internet Database Browser Script Deployment Wizard or manually the software included with the script webdb.asp or webdb.aspx uploaded to the site above;

2, installed in the local Internet database browser;

3, select "New Database Connection", in the script URL domain fill in the URL of the script uploaded to the site, such as: http://www.mysite.com/asp/webdb.aspx, and then select the driver, script URL for the webdb.asp selection "[ASP] Microsoft Access Driver (*.mdb) "DBQ the absolute path of the URL or absolute URL or MDB file that fills the MDB file, such as ... /mdb/mydb.mdb,/mdb/mydb.mdb, C:\Inetpub\wwwroot\mdb\mydb.mdb; the script URL is webdb.aspx selection "[Asp.net]microsoft Jet 4.0 OLE DB Provider ", the Data source filling method and the same as DBQ;

4, click on the new connection, and then enter the password (if any) on it.

Software Download URL:

Official website

Http://www.greatengine.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

Http://www.zdnet.com.cn/download/windows/swinfo/0,2008005031,39176140s,00.htm