怎样在程序中自动创建一个access2000数据库,并给它加上密码保护?
access2000的mdb库什么时候需要压缩?
access2000的mdb库什么时候需要压缩?
解决方案 »
- DLL中的Application
- 请教一下这两个连接串哪个效率更高些?
- 请问用indyftp 如何判断在服务器上的文件是否存在?
- 如一个FORM上有一个PANEL包含很多容器,要在另一个FORM上动态创建一模一样的,怎么做?
- 剪贴板里的数据怎么能存到数据库里?
- 哪位能否讲下delphi中关于pos和copy等含数的用法!!!用了这么久,但是概念很模糊。谢了!!!
- 异常vs异步,BCB那边的不回答,我只好跑到这里来求教
- Delphi6读取多个串口数据
- 我想开始学习delphi,请问学会需要多长时间?
- 学Delphi这么久了,还不知道不用IDE怎样编译Delphi程序??谁会啊?
- 南京的开发人员看过来!!!
- 一般性问题:变量的另一文件的引用
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, comobj,adox_tlb,Graphics, Controls, Forms,
Dialogs, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
Edit1: TEdit;
Edit2: TEdit;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
Catalog: _Catalog;
Table: _Table;
Index : _Index;
//FKey : _key;
strCon:string;//¶¨ÒåÁ¬½Ó×Ö·û´®
yourname:string;
yourpwd:string;
begin
yourname:=trim(edit1.Text);
yourpwd:=trim(edit2.text);
Catalog := CoCatalog.Create;
strCon := 'Provider=Microsoft.Jet.OleDB.4.0;'
//ͨ¹ýJet OleDbÖ±½Ó²Ù×÷AccessÊý¾Ý¿â
+'Data Source=c:\windows\desktop\'+yourname+'.mdb;'
//Êý¾Ý¿âλÖÃ
+'Jet OLEDB:Engine Type=5;'
//Jet 4.x¸ñʽ£¬ÈçΪ4£¬ÔòJet 3.x¸ñʽ
+'Locale Identifier=0x0804;'
//Ö§³Ö¼òÌåÖÐÎÄ£¨Ò»¶¨ÒªÓУ©
+'Jet OLEDB:Database Password='+yourpwd;//密码;
//¼ÓÈëÃÜÂë
Catalog.Create(strCon); //½¨Á¢Êý¾Ý¿â
{½¨Á¢Êý¾Ý±íºÍË÷Òý}
Catalog.Set_ActiveConnection(strCon);
//Á¬½Óµ½Êý¾Ý¿â with Catalog do
begin //½¨Á¢Êý¾Ý±í
Table:= CoTable.Create(); //½¨Á¢TableʵÀý with Table do
begin
Name := 'MyTable1'; //½¨±í MyTable1
Table.ParentCatalog := Catalog ;
Columns.Append('ID',adInteger,8);
Columns.Item['ID'].Properties.Item['AutoIncrement'].Value := true;
Columns.Append('Name',adVarWChar,40);
Columns.Append('Parent_ID',adInteger,8);
Columns.Item['Parent_ID'].Properties['Default'].Value := 0;
Columns.Append('Sort_ID',adInteger,8);
Columns.Append('Counter',adInteger,8);
Columns.Item['Counter'].Properties.Item['Default'].Value := 0; //Êý¾ÝÀàÐÍÏê¼ûMDAC SDK
Tables.Append(Table); //½¨±í MyTable1 Index := CoIndex.Create() as _Index; //½¨Á¢Ë÷Òý
with Index do
begin
Name:='Idx1';
PrimaryKey := True ;
Unique := True;
Columns.Append('ID',adInteger,8);
_Release;
end;
Table.Indexes.Append(Index,EmptyParam); Table._Release;
Table:= CoTable.Create();
end; //with table do
end; //with catalog doend;
uses ComObj;function CreateDatabase(mDatabaseName: string): Boolean;
var
CreateAccess: OLEVariant;
begin
Result := False;
try
CreateAccess := CreateOleObject('ADOX.Catalog');
try
CreateAccess.Create('Provider=Microsoft.Jet.OLEDB.3.51;Data Source=%s%s.mdb';Jet OLEDB:Database Password='+密码+'')
finally
CreateAccess := Unassigned;
end;
except
Exit;
end;
Result := True;
end;
就看下面的:var
CreateAccess: OLEVariant;
begin
Result := False;
try
CreateAccess := CreateOleObject('ADOX.Catalog');
try
CreateAccess.Create('Provider=Microsoft.Jet.OLEDB.3.51;Data Source=%s%s.mdb';Jet OLEDB:Database Password='+密码+'')
finally
CreateAccess := Unassigned;
end;
except
Exit;
end;
Result := True;
end;