How to solve the problem of using Access database to build station maintenance inconvenience

access| Solution | data | database | Problem SELECT Access as the site database, in addition to low-cost reasons, the main Access database is easy to publish, an MDB file includes all the tables and data, after the development with the Web page and ASP scripts uploaded to the site on it, There are also a number of development tools, and many third-party tools are available in addition to Office.

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.