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

ÈÃÈËÎÞÓïµÄAccess¹Ø¼ü×Ö

×ö±ÏÒµÉè¼Æ£¬×î³õ¿¼Âǵ½·½±ãÐÔ£¬ÔÚÑ¡ÔñÊý¾Ý¿âʱ¾ÍÓÃÁËAccess£¨¿ÉÒÆÖ²ÐÔ̫ǿÁË£©£¬ÔÚ²âÊÔʱÅ׳öÁËÕâÑùµÄ´íÎó£º
System.Data.OleDb.OleDbException: INSERT INTO Óï¾äµÄÓï·¨´íÎóÒì³£
±éÑ°ÍøÉϸßÈË£¬Ëµ·¨¶¼¸÷²»Ò»Ñù£¬²»¹ý×îºó»¹ÊÇÕÒµ½ÁËÎÊÌâËùÔÚ£ºAccess±£Áô×Ö£¡
ÒòΪÔÚÊý¾Ý¿âÉè¼ÆÊ±Ã»Óп¼Âǵ½ÁÐÃû»áÓëAccess±£Áô×ÖÖØ¸´£¬Ëì²»ÊǺÜÔÚÒ⣬½á¹û³öÏÖÈç´ËµÍ¼¶´íÎó£¬ÁîÈ˺¹ÑÕ£¡
È»¶ø³öÎÊÌâµÄ¹Ø¼ü×ÖҲͬÑùÈÃÈËÎÞÓÒòΪÕÒµ½ÎÊÌâËùÔÚʱ£¬¾Í¶Ô×ÅAccess±£Áô×Ö±íÒ»Ò»¶ÔÕÕ£¬¿ÉÊÇûÓÐÖØ¸´µÄ°¡?
what a terrible thing!
ÄǾÍÓÃ×µÄ·½·¨ß£¬Äþ¿É´íɱÈýǧ£¬²»ÈÃÒ»ÈËÂ©Íø£¡½á¹û»¹ÕæÈð³ÕÒµ½ÁË£ºposition
position²¢Ã»ÓгöÏÖÔÚAccess±£Áô×Ö±íÖУ¬µ«È´ÊÇAccess±£Áô×Ö£¬Í¦ÈÃÈËÎÞÓïµÄ£¬»»¸öÃû×Ö£¬¸ã¶¨£¡
¸½£ºAccess±£Áô×Ö£¨ºÜ¿ÉÄܳöÏÖ±¾ÈËÓöµ½µÄÎÊÌ⣬ËùÒÔ»¹³öÏÖÎÊÌâµÄ»°¾ÍÖ»ÓÐÓÃ×µÄ·½·¨one by oneÁË£©
ÒÔÏÂΪAccessÊý¾Ý¿â¹Ø¼ü×Ö:
-A

ADD
ALL
Alphanumeric
ALTER
AND
ANY
Application
AS
ASC
Assistant
AT
AUTOINCREMENT
Avg
-B

BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
CreateDatabase
CreateField
CreateGroup
CreateIndex
CreateObject
CreateProperty
CreateRelation
CreateTableDef
CreateUser
CreateWorkspace
CURRENCY
CurrentUser
-D

DATABASE
DATE
DATETIME
DELETE
DESC
Description
DISALLOW
DISTINCT
DISTINCTROW
Document
DOUBLE
DROP
-E

Echo
Else
End
Eqv
Error
EXISTS
Exit
-F

FALSE
Field, Fields
FillCache
FLOAT, FLOAT4, FLOAT8
FOREIGN
Form, Forms
from
Full
FUNCTION
-G

GENERAL
GetObject
GetOption
GotoPage
GROUP
GROUP BY
GUID
-H

HAVING
-I

Idle
IEEEDOUBLE, IEEESINGLE
If
IGNORE
Imp
IN
INDEX
Index, Indexes
INNER
INSERT
InsertText
INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
INTO
IS
-J
JOIN
-K

KEY
-L

LastModified
LEFT
Level
Like
LOGICAL, LOGICAL1
LONG, LONGBINARY, LONGTEXT
-M

Macro
Match
Max, Min, Mod
MEMO
Module
MONEY
Move
-N

NAME
NewPass


Ïà¹ØÎĵµ£º

vb.net²Ù×÷Êý¾Ý¿âÖ®ACCESS£¨3£©

ÕâһƪÎÒÔÙ˵˵ˮ¾§±¨±íµÄÇé¿ö¡£ACCESSÖжÔӦˮ¾§±¨±í·½Ã棬´ó¼Ò¿ÉÄÜ»áÓöµ½µÄ×î¶àµÄÎÊÌâÓ¦¸Ã¾ÍÊÇ´ò¿ª±¨±íºó
»á³öÏÖÐèÒªµÇ¼µÄÎÊÌâ¡£
Õâ¸öÊÇÎªÊ²Ã´ÄØ£¿Ã÷Ã÷ÎÒûÓÐÉèÖÃÃÜÂ룬Ôõô»áÓÐÒªÊäÈëÃÜÂëÄØ£¿Èç¹ûÄã¹»³Á×Å£¬Èç¹ûÄãµÄdebug¾­Ñ鲻ȱ·¦µÄ»°£¬
Äã»á·¢ÏÖÔÚË®¾§±¨±íÌø³öÊäÈëÃÜÂëµÄµÇ¼¿òÖУ¬accessµÄ·¾¶²»ÊÇÎÒÏÖÔÚÊý¾Ý¿â· ......

C#²Ù×÷AccessÀà Re

using System;
using System.Data;
using System.Data.OleDb;
namespace AccessDb
{
/**//// <summary>
/// AccessDb µÄժҪ˵Ã÷£¬ÒÔÏÂÐÅÏ¢ÇëÍêÕû±£Áô
/// ÇëÔÚÊý¾Ý´«µÝÍê±Ïºóµ÷ÓÃClose()·½·¨£¬¹Ø±ÕÊý¾ÝÁ´½Ó¡£
/// </summary>
public class AccessDbClass
{
±äÁ¿Éù ......

º£³ÇÊÐÄĮ̈Êг¡¹Üί»á ACCESSÊý¾Ý»Ö¸´³É¹¦Êý¾Ý»Ö¸´












¿Í»§Ãû³Æ
º£³ÇÊÐÄĮ̈Êг¡¹Ü ......

ʹÓÃaspÁ¬½Óaccess2007×¢ÒâÊÂÏî

ǰ¼¸ÌìÔÚ×Ô¼ºµÄ±Ê¼Ç±¾Éϰ²×°ÁËOFFICE2007¡£½ñÌì×öÁËÒ»¸ö°Ù¶ÈÓÑÇéÁ´½Ó¼ì²éµÄ¹¤¾ß£¬ ÔÚÁ¬½ÓACCESS2007Êý¾Ý¿âµÄʱºò£¬Ê¹ÓõÄÇý¶¯´úÂëΪ£º"provider=microsoft.jet.oledb.4.0;data source="&server.mappath("queryrecord.mdb") ¡£È··¢ÏÖÌáʾ£º
Microsoft JET Database Engine ´íÎó ''80004005''
²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ
µ« ......

asp.netÁ¬½ÓaccessÊý¾Ý¿â½øÐÐÌí¼Ó¸üÐÂɾ³ý²éѯ²Ù×÷

Á¬½ÓaccessÊý¾Ý¿â´úÂ룬дÔÚÒ»¸öµ¥¶ÀµÄÀàÀï
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace AppWebDLL
{
    public class ConnApp
    {
       ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ