Çë½ÌaccessÊý¾Ý¿â¶¯Ì¬Éú³ÉµÄÎÊÌâ
//**********************************
//³ÌÐò¹¦ÄÜ£º´´½¨AccessÊý¾Ý¿âºÍÊý¾Ý±í
//**********************************
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ComObj, ADODB, StdCtrls;
type
TForm1 = class(TForm)
Button1: TButton;
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
Path: string;
implementation
{$R *.dfm}
procedure TForm1.FormCreate(Sender: TObject);
begin
Path := ExtractFilePath(Application.ExeName);
end;
//Êý¾Ý¿â´´½¨¹ý³Ì
procedure TForm1.Button1Click(Sender: TObject);
var
CreateAccess: OleVariant;
begin
//Èç¹û´æÔÚͬÃûÎļþ£¬Ôòɾ³ýÖ®
if FileExists(Path + 'A1.mdb') then
begin
DeleteFile(Path + 'A1.mdb');
end;
CreateAccess := CreateOleObject('ADOX.Catalog');
CreateAccess.Create(
Ïà¹ØÎÊ´ð£º
±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬
ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......
Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ.
ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%,
ÔÙÔÚ²é詢 ......
ÔÚaccessÖÐÔõôִÐÐselect TOP (@size) * from table1
Õâ¸öTOPÔõô´ø²ÎÊý²éѯ°¡
ÓÃVBA¶¯Ì¬Éú³ÉSQLÓï¾ä£¬ÔÙÖ´ÐÐ
²»ÄÜÖ±½ÓÓÃSQLÓï¾ä£¬ÓÃ×Ö·û´®ÀÛ¼ÓÉú³ÉSQLÓï¾äµÄ·½·¨À´Ö´ÐÐSQLÓï¾ä
top n Õâ¸öûÓа취ʹÓò ......
string strAdd = "update tb_Note set Note='" + richTextBox1.Text + "' where NoteCode='"+strflag +"'"
¶¼ÊÇÎı¾ÀàÐ͵Ä
ÍêÈ«ÕýÈ·¡£
Äã²»ÊÔһϾÍÌá¸ß
......
´ÓÀàÐÍ"DBNULL" µ½ÀàÐÍ¡°Double¡±µÄת»»ÎÞЧ£¨Êý¾Ý¿âÖжÔÓ¦µÄ a3 »òa5 ûÓÐÊý¾ÝÊÇΪ¿Õ£©
,ÇëÎÊÎÒÔõô´¦Àí£¡
VB.NET code:
Dim a1 As String = Nothing
Dim a2 As S ......