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

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/add.asp, line 10

HTML code:
<form name="form1" method="post" action="addmsg.asp">
ÄãµÄÐÕÃû£º<input type="text" name="name"><br>
ÄãµÄµç»°£º<input type="text" name="tel"><br>
ÄãµÄÁôÑÔ£º<input type="text" name="message" value=""><br>
<input type="submit" name="submit" value="Ìá½»">
<input type="reset" name="submit2" value="ÖØÖÃ">
</form>
<%
set conn= server.createobject("adodb.connection")
conn.open "driver={microsoft access driver(*.mdb)};dbq=" & server.mappath("database\guestbook.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(username, tel, message) values ('" & name & "', "& tel & &qu


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

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

ÎÊÌâÈçÏ£º

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

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

Çë½ÌÒ»¸öACCESSµÄ²éѯÓï¾ä£¡

Òª×éºÏ4ÕűíµÄ²éѯ£¬·Ö±ðÊÇA±í£¬B±í£¬C±í£¬D±í£»
A±í
Game_id  Game_Name
  1        abc


B±í
Category_ID  Category_Name  Game_id
  & ......

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì

access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»

Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.

DTS ²»Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ