Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶¯Ì¬´´½¨accessÊý¾Ý¿âµÄÎÊÌâ2

´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£

Ô´ÂëÈçÏ£º
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½

procedure Tfrmweihu.btncjsjkClick(Sender: TObject);
var
path,StrSQL:string;
CreateAccess: OleVariant;
ADOConn: TADOConnection;
const
AConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s';
begin
//´´½¨Êý¾Ý¿âÎļþ
Path := ExtractFilePath(Application.ExeName);
if FileExists(Path + 'mydata.mdb') then
  begin
  showmessage('Êý¾Ý¿âÎļþÒѾ­´æÔÚ£¡');
  exit;
  end;
CreateAccess:=CreateOleObject('ADOX.Catalog');
CreateAccess.Create('Provider=Microsoft.Jet.OLEDB.4.0;Data Source= '+Path+'mydata.mdb');

//´´½¨Êý¾Ý±í
ADOConn:=TADOConnection.create(self);
ADOConn.ConnectionString:=Format(AConnectionString,[Path +'mydata.mdb','']);
Strsql := 'create table mydata (ID autoincrement PRIMARY KEY not null,±êÇ©1 char(50) not null,±êÇ©2 char(50),±êÇ©3 char(50),±êÇ©4 char(50),±êÇ©5 char(50),±êÇ©6 char(50),ÕýÎÄ1 text not null,ÕýÎÄ2 text,ÈÕÆÚ Datetime not null)';
ADOConn.Execute(strsql);
ADOConn.Close;
ADOConn.Free;
Showmessage('Êý¾Ý±í´´½¨³É¹¦,'+#13#10+'ÇëÖØÐÂÆô¶¯±¾³ÌÐò£¡');


Ïà¹ØÎÊ´ð£º

access vba Êý×鳤¶È

access vba ÖÐÔõôȡµÃÊý×鳤¶È£¿
Êý×éÐУ¿
UBound(Êý×éÃû)

ubound()-lbound()

UBound º¯Êý
     

·µ»ØÒ»¸ö Long ÐÍÊý¾Ý£¬ÆäֵΪָ¶¨µÄÊý×éά¿ÉÓõÄ×î´óϱꡣ

Óï·¨ ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ACCESSÆøËÀÎÒÁË£¬MD£¬×Ö¶ÎÖµ²»¶Ô

ÎÒÒª´ÓACCESS²éѯһÐÐÊý¾Ý,Êý¾Ý¿âÀïÓÐ ip£º192.168.2.71£¬192.168.2.55
SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.55')£¬ÄÜÑ¡³öÊý¾ÝÀ´
SELECT COUNT(*) AS num from TreeNode WHE ......

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

AccessÁ¬½ÓÓï¾ä²éѯ½á¹ûÓësql2005²»Ò»ÖÂ

SQL code:

select count(1) from HouseList a left join MemberList b on
(a.OperationName=b.UName and a.Eid=1 and a.houselc='2')

ÒÔÉÏÕâÌõÓï¾äÔÚsql2005ÖвéѯµÃµ½760Ìõ¼Ç¼,·ÅÔÚaccessÖвéѯֻÓÐ14Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ