引用DAO3.6建立ACCESS2000数据库,引用DAO3.5建立ACCESS97数据库
Dim db As Database
Set db = CreateDatabase("c:\new.mdb", dbLangChineseSimplified)
db.Close
Dim db As Database
Set db = CreateDatabase("c:\new.mdb", dbLangChineseSimplified)
db.Close
Dim MyDatabase As Database
Set MyDatabase = CreateDatabase(cProgramPath + "\Trade.mdb", dbLangGeneral, dbEncrypt)
Set MyTable = MyDatabase.CreateTableDef("System")
Set MyField = MyTable.CreateField("APPLNAME", dbText, 100) '项目名称
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("SERVERNAME", dbText, 15) '服务器名称
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("LOGONNAME", dbText, 15) '数据库用户
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("PASSWORD", dbText, 15) '数据库口令
MyTable.Fields.Append MyField
Set MyField = MyTable.CreateField("DATANAME", dbText, 15) '数据库名称
MyTable.Fields.Append MyField
MyDatabase.TableDefs.Append MyTable
'MyDatabase.NewPassword "", "allway"
MyDatabase.Close
要用的时候,用FileCopy命令就可以获得一个新公司的数据库文件了。