apollo(阿波罗):怎么用?最好有代码
解决方案 »
- 什么网站是FTP类型网站?
- VB WebBrowser点击网页跳转的SESSION(或cookies)问题
- 用text编辑msflexgrid的问题.
- 大量客户端向数据服务器发送UDP数据,服务器是否会发生假死或丢包现象?
- DataGrid集合显示问题在次给分,洪根大哥请进~(100分)
- 请问如何提高ADO对ACCESS添加,查询数据的效率
- 看看这个问题除了能难住我还能难住谁?
- 急,关于RecordSet的update问题
- 中小型超市POS收银系统的软件
- 我受不了msdn了,谁能告诉我有效的使用方法。
- 已知一个已运行的外部程序的句柄,如何使它最从最大化或正常显示(结束最小化)?
- 一个关于引用ADO打包安装的问题!高手们快快帮忙!!!
'在SQLserver 中建立一个库
Dim SQL$
SQL = ""
SQL = SQL & "CREATE DATABASE " & Files
SQL = SQL & " ON "
SQL = SQL & "( NAME = '" & Files & "_dat',"
SQL = SQL & " FILENAME = '" & Paths & Files & "_dat.jdt',"
SQL = SQL & " SIZE = 10MB,"
SQL = SQL & " MAXSIZE = 50MB,"
SQL = SQL & " FILEGROWTH = 5MB )"
SQL = SQL & "LOG ON"
SQL = SQL & "( NAME = 'Sales_log',"
SQL = SQL & " FILENAME = '" & Paths & Files & "_log.jdt',"
SQL = SQL & " SIZE = 5MB,"
SQL = SQL & " MAXSIZE = 25MB,"
SQL = SQL & " FILEGROWTH = 5MB )"
'On Error GoTo Err1
Cm.Execute SQL
Creat_Database = True
Exit Function
Err1:
Creat_Database = False
End Function
'生成数据库
Dim myAc As New ADODB.Connection
Dim myAm As New ADODB.Command
'dbname 数据库名称
CreateDB = True
dbname = "NBUF_" & txtAccCode & "_" & txtYear.Text
On Error GoTo err_proc
With myAc
.ConnectionString = "driver=SQL Server;server=" & computerName & ";uid=nbufsoft;pwd=nbufsoft;database=master"
.CommandTimeout = 30
.Open
End With
With myAm
.ActiveConnection = myAc
.CommandText = "create database " & dbname & " on (name=" & dbname & "_data" & ", filename='" _
& txtAccPath.Text & dbname & ".mdf') log on (name=" & dbname & "_log" & ",filename='" & txtAccPath.Text & dbname & ".ldf')"
.Execute
End With
myAc.Close
Exit Function
err_proc:
MsgBox "建立数据库失败,原因为:" & Err.Description, vbExclamation, CW
With myAc
If .State = adStateOpen Then .Close
End With
CreateDB = False
End Function
TO progame()上班也可以在网上的,哈哈