| 发表于:2008-01-17 10:13:16 楼主 |
private sub command1_click() dim fm as string 'fm变量用来获取用户输入的文件名 commondialog1.filter = "mdb文件(*.mdb) ¦*.mdb ¦allfiles(*.*) ¦*.* ¦" commondialog1.filterindex = 1 commondialog1.initdir = "e:jthpaper" commondialog1.flags = 6 commondialog1.action = 2 if commondialog1.filename = "" then msgbox "你必须输入一个文件名,请重新保存一次!" exit sub else fm = commondialog1.filename end if pstr = "provider=microsoft.jet.oledb.4.0:" '不能把这里的4.0改为3.51 pstr = pstr & "data source=" & fm cat.create pstr ????????????运行出出错位置 '创建数据库 dim tbl as new table cat.activeconnection = pstr tbl.name = "mytable" '表的名称 tbl.columns.append "编号", adinteger '表的第一个字段 tbl.columns.append "姓名", advarwchar, 8 '表的第二个字段 tbl.columns.append "住址", advarwchar, 50 '表的第三个字段 cat.tables.append tbl '建立数据表 conn.open pstr rs.cursorlocation = aduseclient rs.open "mytable", conn, adopenkeyset, adlockpessimistic rs.addnew '往表中添加新记录 rs.fields(0).value = 9801 rs.fields(1).value = "孙悟空" rs.fields(2).value = "广州市花果山" rs.update end sub private sub command2_click() set datagrid1.datasource = rs end sub private sub command3_click() rs.updatebatch end sub private sub form_load() dim cat as new adox.catalog '不用cat用另外一个名字也可以 dim conn as new adodb.connection dim rs as new adodb.recordset dim pstr as string '定义该变量是为了后面的书写方便 end sub 之前已经引用了"microsoft activex data objects 2.5 library"和"microsoft ado ext 2.1. for ddl security"。 请大家帮忙分析一下。是因为什么出错呢,是我的vb中没有某项功能吗,比如microsoft.jet.oledb.4.0,adox.catalog谢谢 |
|
|
|
|