当前位置:学学看123知识中心电脑教学数据库教程创建一个空数据库» 正文

创建一个空数据库

[06-11 18:15:58]   来源:http://www.xxk123.com  数据库教程   阅读:8254

导读:Function CreateNormalDB(strPathName As String) As BooleanOn Error GoTo Exit_ERRDim wrkDefault As WorkspaceDim NewDB As DatabaseCreateNormalDB = FalseSet wrkDefault = DBEngine.Workspaces(0)If Dir(strPathName) <> "" Then Kill strPathNameSet NewDB = wrkDefault.CreateDatabase(strPathName, dbLangGeneral)NewDB.CloseSet NewDB = NothingCreateNormalDB = TrueExit Function Exit_ERR:MsgBox "备份失败!" & vbCrLf & vbCrLf & Err.Description, vbExclamationExit FunctionEnd Func

创建一个空数据库,标签:sql数据库教程,access数据库教程,http://www.xxk123.com
Function CreateNormalDB(strPathName As String) As Boolean
On Error GoTo Exit_ERR
Dim wrkDefault As Workspace
Dim NewDB As Database

CreateNormalDB = False
Set wrkDefault = DBEngine.Workspaces(0)
If Dir(strPathName) <> "" Then Kill strPathName
Set NewDB = wrkDefault.CreateDatabase(strPathName, dbLangGeneral)

NewDB.Close
Set NewDB = Nothing

CreateNormalDB = True
Exit Function

Exit_ERR:
MsgBox "备份失败!" & vbCrLf & vbCrLf & Err.Description, vbExclamation
Exit Function
End Function

'调用时只需提供路径及文件名即可,此函数为备份数据模块的一部份


Tag:数据库教程sql数据库教程,access数据库教程电脑教学 - 数据库教程
前一篇:隐藏 Access 窗口
《创建一个空数据库》相关文章

Copyright 学学看123 All Right Reserved.

1 2 3 4 5 6 7 8 9 10