ASP s Access data connection

The tables in your database are opened in Design View.

2.Use the FTP tool to create a mytest folder in the virtual server and upload the database to the mytest folder.

3.In the mytest folder, create a new file with the following contents:

set conn="")

driver=;dbq=" & dbpathsql="select * from table_1 order by id asc"

set rs="")

sql,conn,1,1

do while not

name"))

loopset rs=nothing

set conn=nothing

4.Then enter the domain name mytest in the address bar, and the result will be displayed as shown below. The query is "name"."The value of the field.

The previous page uses pagination technology.

Read the database ID, the time of the article title.

sql="select id,names,time from sxyw"

sql,conn,1,1

.Pagination technology.

do while...

& rs("names") &""

loop page 2:

Determine the content based on the ID of the click.

sql = "select names,intro,time from sxyw where id=" & request("id")

sql,conn,1,1

..Displays the action.

Here's how it goes.

I think it's good, and the access evaluation is as follows.

Advantages: (1) It has an intuitive query analyzer (although it cannot be regarded as a real query analyzer), and it is relatively easy to maintain.

2) The performance is average, but relatively mature and stable.

Disadvantages: (1) The limit command is not supported, and the data cannot be directly paged. A common combination of 3 select commands can significantly slow down performance.

2) INSERT does not support returning an incrementing ID, and there is no perfect solution to this problem so far.

3) Poor concurrency performance, with a maximum concurrency of 50. And as long as there is one connection, other connections cannot modify the data.

4) The compression database command is not supported.

5) Dynamic database creation is not supported.

6) Cross-platform is not supported.

It's okay to use access to make a small **, the number of visits is not very large, and there is no difference in speed, but once there are many users or the database query data is large, the performance will be significantly reduced.