Access Web Êý¾Ý¿âºÍ Access չʾ
Access ÏîÄ¿¹ÜÀíÍÅ¶ÓµÄ Clint ÔÚ´ËÏò Office ¹¤³Ì²©¿ÍµÄ¶ÁÕß±íʾÎʺò¡£Í¨¹ýÓëµÚ 9 ƵµÀºÏ×÷£¬Access ÍŶӼ´½«ÍƳöÒ»¸öÃûΪ Access չʾµÄÐÂչʾ¡£ÆäÖ÷ÒªÈËÎï°üÀ¨ Ryan McMinn¡¢ÎÒ±¾ÈËÒÔ¼°ÍŶӵÄÆäËûÈËÔ±¡£ÎÒÃǽ«ÉîÈë̽ÌÖ Access 2010 ºÍ Access Services ÖеÄÐÂÔö¹¦ÄÜ£¬²¢·ÖÏíÀ´×ÔÉçÇøµÄ·´À¡¡£
´ËÍ⣬×î½üÔÚ SharePoint Developers Conference ÖУ¬ÎÒÃÇ»¹Åû¶ÁËÓÐ¹Ø Access 2010 µÄзþÎñÆ÷¹¦ÄÜ“Access Services”µÄ¸ü¶àÏêϸÐÅÏ¢¡£Access Services ÊÇÒ»¸öÐ嵀 SharePoint 2010 ¹¦ÄÜ£¬ËüÔÊÐíÓû§Ê¹Óà Access ×ÀÃæÓ¦ÓóÌÐò´´½¨¿Éͨ¹ýä¯ÀÀÆ÷·ÃÎʵÄÊý¾Ý¿â£¬²¢½«ÆäÖÃÓÚ SharePoint ÖС£Í¨¹ý Access 2010 ºÍ Access Services£¬Äú¿ÉÒÔÈÃ×éÖ¯±£³ÖÁéÃô¡¢Êý¾Ý±£³Ö°²È«£º
ÏòÓû§Ìṩһ¸öÒ×ÓÚ¹ÜÀíµÄ½â¾ö·½°¸£¬ÒԱ㴴½¨¡¢¹²ÏíºÍÐ×÷´¦ÀíÍŶÓÊý¾Ý¿â¡£
ͨ¹ý½µµÍ¿ª·¢ºÍά»¤³É±¾½ÚÊ¡×ʽð¡£
ͨ¹ýÒ»¼üʽÉçÇøÄ£°å¸ü¿ìµØ¿ªÊ¼¹¤×÷¡£
ÏÂÃæÊÇ×ʼµÄÒ»¶ÎÇé½ÚÒÔ¼° Ryan ´´½¨ÔÚä¯ÀÀÆ÷ÖÐÔËÐÐµÄ Access Services Ó¦ÓóÌÐòµÄÒ»¸ö¼ò¶ÌÑÝʾ£º
Äú¿ÉÒÔͨ¹ý Access 2010 ¼ò½éϵÁÐ RSS Ô´Á˽âÓйش˴η¢²¼µÄ¸ü¶àÐÅÏ¢¡£
ÂýÂýÐÀÉÍ°É£¡
Ïà¹ØÎĵµ£º
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......
<!--#include file="config.asp" -->
<!--#include file="Fun.asp" -->
<%
'Êý¾Ý¿â¹ÜÀíÀà
class Datas
'±¸·Ý
public sub Bk()
Set fso=server.createobject("scripting.filesystemobject")
fso.CopyFile Server.MapPath(SiteDataPath),Server.MapPath(SiteDataBakPath)
......
½â¾ö°ì·¨£º
´Ó Windows µÄ“¿ªÊ¼”²Ëµ¥£¬Ö¸Ïò“³ÌÐò”¡¢ “Visual Studio .NET 2003”¡¢“Visual Studio .NET ¹¤¾ß”£¬È»ºóÑ¡Ôñ“Visual Studio .NET ÃüÁî Ìáʾ”¡£ÔÚ´°¿Ú´ò¿ªºó£¬¼üÈë aspnet_regiis /i¼´¿É¡£
²»¿ÉÐеķ½°¸£º
1¡¢ÖØÆôµçÄÔ¡£
2¡¢É¾³ý»º´æ¡£
3¡¢ÖØÐ ......
¡øÈÕÆÚ
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1","2006-6-1")·µ»Ø31,ÆäÖÐd¿ÉÒÔ»»Îªyyyy,m,HµÈ
DatePart ·µ» ......
ÔÚaccessÖУ¬updateÓï¾ä²»ÄÜÓÐ×Ó²éѯµÄ£¬Èç²»ÔÊÐíÈçÏÂÓï¾ä³öÏÖ£º
UPDATE tblA SET lngID=
(SELECT lngID from tblB WHERE strName='nihao')
ÕâÑù¾ÍÐèÒªÁíÏë°ì·¨½â¾öÎÊÌâ¡£
½â¾ö·½°¸£º
A¡£
¿ÉÒÔÓÃupdateÁíÍâµÄÓï·¨½â¾ö£º
UPDATE Tab1 a,(Select ID,Name from Tab2) b
SET a.Name = ......