Online database management tool db007 download://www.Vevb.com/codes/6195.html
The code copy is as follows:
<!--
'************************************
'*use:
'^Processing access and sql databases online in the view interface
'*Author: Guan Shijie
'*Creation date: 2006-5-28
'*2006-06-04 Added data modification function
'*2006-06-10 Added the function of inserting data in empty tables
'*2006-09-8 Added the function of modifying field name and table name to correct some errors
'*Execute sql, if it is select, it will return the result, otherwise it will return the result
'*This program can be used for free. Please keep this information when reprinting
'************************************
-->
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<title>Online database management tool db0071.5</title>
<styletype="text/css">
<!--
body,td,th{font-family:"安体";font-size:12px;}
form{margin:0px;padding:0px;}
body{margin:5px;SCROLLBAR-ARROW-COLOR:#666666;SCROLLBAR-FACE-COLOR:#DDDDD;SCROLLBAR-DARKSHADOW-COLOR:#999999;SCROLLBAR-HIGHLIGHT-COLOR:#FFFFF;SCROLLBAR-3DLIGHT-COLOR:#CCCCCC;SCROLLBAR-SHADOW-COLOR:#FFFFF;SCROLLBAR-TRACK-COLOR:#EEEE;}
input{border-width:1px;border-style:solid;border-color:#CCCCCC#999999#999999#CCCCCC;height:16px;}
td{background:#FFF;}
textarea{border-width:1px;border-style:solid;border-color:#CCCCCC#999999#999999#CCCCCC;}
a:link{text-decoration:none;}
a: visited{text-decoration:none;}
a:hover{text-decoration:underline;}
a:active{text-decoration:none;}
.fixSpan{width:150px;white-space:nowrap;word-break:keep-all;overflow:hidden;text-overflow:ellipsis;}
-->
</style>
</head>
<body>
<%
ifrequest("key")="db"then
session("dbtype")=request("dbtype")
session("dbstr")=request("dbstr")
response.redirect"?"
endif
ifrequest("key")="createdatabase"then
callcreatedatabase()
endif
ifsession("dbtype")=""orsession("dbstr")=""then
%>
<formaction="?key=db"method="post"name="dbt">
<br>
Connection type:
<inputname="dbtype"type="radio"value="access"onClick="dbstr.value='Provider=Microsoft.Jet.OLEDB.4.0;PersistSecurityInfo=False;Password=;DataSource=<%=server.mappath("/")&"/"%>'"checked>