sSql := 'insert into hb(hbbh,hbzl,shunxu,nian,cezhan) in d:\test.mdb select hbbh,hbzl,shunxu,nian,cezhan from hb ';
with adoConnection1 do
begin
Connected := True;
Execute(sSql);
end;
在程序中,d:\test.mdb的test数据库带有密码比如 123,请问怎样写这段过程,
with adoConnection1 do
begin
Connected := True;
Execute(sSql);
end;
在程序中,d:\test.mdb的test数据库带有密码比如 123,请问怎样写这段过程,
insert into hb(hbbh,hbzl,shunxu,nian,cezhan) in d:\test.mdb [pwd='数据库密码';] select hbbh,hbzl,shunxu,nian,cezhan from hb 试试看
带password的access连接字符串随便找个向导都能写的。