标题:请问我的这段data控件代码为什么创建的accsee是95格式的,怎么改成97格式的 ...
只看楼主
cynblx
Rank: 1
等 级:新手上路
帖 子:5
专家分:0
注 册:2006-4-10
 问题点数:0 回复次数:0 
请问我的这段data控件代码为什么创建的accsee是95格式的,怎么改成97格式的啊?
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
请大家帮帮忙了
搜索更多相关主题的帖子: data accsee 控件 格式 代码 
2006-05-11 12:25



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-63378-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.138965 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved