你是我的生命裴书玲:请问我的这段data控件代码为什么创建的accsee是95格式的,怎么改成97格式的啊?

来源:百度文库 编辑:中科新闻网 时间:2024/05/09 05:45:19
Set db = CreateDatabase(App.Path + "\shujuzunku", dbLangChineseSimplified, dbEncrypt)
SQL = "create table[tuser]([tname]text(20),[tpassword] text(20))"
db.Execute SQL
SQL = "create table [shujukbb]([bianhao]text(10),[mingcheng]text(50),[shuliang]int,[danjia]float,[congruriqi]text(14),[jingbanren]text(16),[beizhu]text(100))"
db.Execute SQL
SQL = "create table [chushou]([bianhao]text(10),[mingcheng]text(50),[shuliang]text(50),[danjia]text(50),[chushouriqi]text(14),[jingbanren]text(16),[beizhu]text(100))"
db.Execute SQL
SQL = "create table [chuzu]([bianhao]text(10),[mingcheng]text(50),[shuliang]text(50),[kehuname]text(16),[yajing]text(50),[zujing]text(50),[chuzuriqi]text(14),[jingbanren]text(16),[beizhu]text(100))"
db.Execute SQL
SQL = "create table [yejicha]([jiankuri]text(12),[kucongshu]text(50),[kongcongjia]text(50),[chushoushu]text(50),[chushoujia]text(50),[chuzushouru]text(50))"
db.Execute SQL
Set tb = db.OpenRecordset("yejicha", dbOpenDynaset)
mhp = Date
tb.AddNew
tb.Fields("jiankuri") = mhp
tb.Fields("kucongshu") = "0"
tb.Fields("kongcongjia") = "0"
tb.Fields("chushoushu") = "0"
tb.Fields("chushoujia") = "0"
tb.Fields("chuzushouru") = "0"
tb.Update
Set ttable = db.OpenRecordset("tuser", dbOpenDynaset) '创建数据库和表
ttable.AddNew '向表中加入系统默认的用户名和密码
ttable.Fields("tname") = "系统管理员"
ttable.Fields("tpassword") = "0"
ttable.Update
Data1.Refresh
可以访问ACCESS97格式的,怎么把他改成建立的数据库是97格式的
data是老版本的,可它能访问ACCESS97格式的,应该也能创建97格式的数据库吧,我现在建的是95格式的,我想让它自动建成97格式的