在ACCESS数据库中添加一个新表,为什么不能用中文??
private Function creat()
Dim testdb As Database
Dim testtd As TableDef
Dim testfield1 As Field
Dim testfield2 As Field
Dim testfield3 As Field
Dim testfield4 As Field
Dim testfield5 As Field
Dim testfield6 As Field
Dim testfield7 As Field
Dim testfield8 As Field
Dim testfield9 As Field
Dim testfield10 As Field
Set testdb = OpenDatabase(c:\"111.mdb")
Set testtd = testdb.CreateTableDef(Form10.Text1.Text)
Set testfield1 = testtd.CreateField("姓名", dbText)
Set testfield2 = testtd.CreateField("性别", dbText)
testtd.Fields.Append testfield1
testtd.Fields.Append testfield2
testdb.TableDefs.Append testtd
end function
如果字段都用中文(姓名,性别)就会出错,提示“性字段别已经在表中”
如果换成英文名称作为字段就没有任何问题,或者在性别两个字中间加空格也没问题
这是为什么?是因为中文参与数据库运算不兼容吗?还是什么别的原因?
谢谢大家指导
岂能尽如人意,但求无愧我心,很高兴认识大家!
QQ:341157
E-mail:daryl@ihw.com.cn