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

¹ØÓÚEXTERNAL ACCESS ASSEMBLYȨÏÞÉèÖà ¼±¼±£¡£¡£¡

ÏîÄ¿ÐèÒª´´½¨³ÌÐò¼¯£¬²¢¶Ô¸Ã³ÌÐò¼¯ÉèÖÃEXTERNAL_ACCESSȨÏÞ£¬ÒÔÍê³ÉÍⲿ·ÃÎʹ¦ÄÜ£¬±ÈÈç²ÉÓÃÈçÏÂÓï¾ä£º
create assembly assemblyName(³ÌÐò¼¯Ãû³Æ) from 'D:\dllName.dll' with permission_set = external_access
»á³ö´í£¬ÌáʾÈçÏ£º
Õë¶Ô³ÌÐò¼¯'dllName'µÄCREATE ASSEMBLYʧ°Ü£¬ÒòΪ³ÌÐò¼¯'dllName'δ»ñÊÚȨ£¨PERMISSION_SET = EXTERNAL_ACCESS£©.
µ±·ûºÏÒÔÏÂÁ½¸öÌõ¼þ֮һʱ£¬½«¶Ô³ÌÐò¼¯ÊÚȨ£ºÊý¾Ý¾ÝËùÓÐÕß¾ßÓÐEXTERNAL ACCESS ASSEMBLYȨÏÞ£¬¶øÇÒÊý¾Ý¿âµÄ
TRUSTWORTHYÊôÐÔ´¦ÓÚ´ò¿ª×´Ì¬£»»òÕߣ¬³ÌÐò¼¯Ç©ÃûʱËùʹÓõÄÖ¤Êé»ò·Ç¶Ô³ÆÃÜÔ¿Ëù¶ÔÓ¦µÄµÇ¼Ãû¾ßÓÐEXTERNAL ACCESS
ASSEMBLYȨÏÞ¡£


ÉÏÊöÎÊÌâÀ§ÈÅÎÒÄÑÒÔ½â¾ö£¬Çë¸ßÊÖÖ¸µã£¡£¡£¡

Êý¾Ý¿âËùÓÐÕß¶ÔÓ¦µÄµÇ½ÕË»§¶Ô SQL SERVER ʵÀýÓµÓÐ EXTERNAL ACCESS ASSEMBLY ȨÏÞ£¨GRANT EXTERNAL ACCESS ASSEMBLY TO loginame £©£»½«Êý¾Ý¿âÉèÖÃΪ¿ÉÐÅÈεģ¨ALTER DATABASE dbname SET TRUSTWORTHY ON£©¡£



ͬÒâ1Â¥.

1Â¥£¬¿ÉÒÔÔÙ¾ßÌåµãÂ𣿣¿

»¹Òª¾ßÌ壿

ÔÚ´´½¨³ÌÐò¼¯Ç°£¬Ö´ÐÐÒÔÏÂÓï¾ä£º
GRANT EXTERNAL ACCESS ASSEMBLY TO loginame
ALTER DATABASE dbname SET TRUSTWORTHY ON
£¨dbname Ϊ׼±¸´´½¨µÄ³ÌÐò¼¯ËùÔÚµÄÊý¾Ý¿â£¬loginame Ϊ¸ÃÊý¾Ý¿âµÄËùÓÐÕß¶ÔÓ¦µÄµÇ½ÕË»§£©

¸Ðл¥ÉϵİïÖúÓëÖ¸µ¼£¬ÎÒ°´ÉÏÃæµÄ×öÁË»¹ÊDz»ÐС£
¾ßÌåÊÇÕâÑùµÄ£º
1 ÔÚmasterϵͳÊý¾Ý¿âÏÂÖ´ÐÐ
GRANT EXTERNAL ACCESS ASSEMBLY TO loginame
ALTER DATABASE dbname SET TRUSTWORTHY ON
ÆäÖУ¬loginame Ϊ׼±¸´´½¨µÄ³ÌÐò¼¯µÄËùÓÐÕßaa¶ÔÓ¦µÄµÇ½Ãû
aaÊÇÔÚÊý¾Ý


Ïà¹ØÎÊ´ð£º

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

VB.net²Ù×÷AccessÎÊÌâ

ÓõÄÊÇ2008дÁËÒ»¶ÎÅжÏÊý¾Ý¿âDbNameÖÐÊÇ·ñÓбíTabNameµÄ³ÌÐò£¬µ«ÊÇÔÚµ÷ÓõÄʱºò³öÏÖÁËÊý¾Ý¿âÃû³Æ²»ÄÜת»»ÎªDoubleÐÍÊý¾ÝµÄÎÊÌ⣬µ«ÊÇÔÚÕâµ±ÖÐÎÒ¸ù±¾Ã»ÓÐÉèÖÃDoubleÐÍÊý¾Ý£¬¸Õ¿ªÊ¼½Ó´¥VB.net£¬²»ÊǺܶ®£¬´ó¼Ò°ïæ°¡ ......

accessÁбí¿òÊý¾Ý¶ªÊ§

¸÷λ´óÏÀ£º
            ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
  µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔ­À´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......

µ¼Èëexcel±í¸ñµ½accessºó²úÉúµÄÎÊÌ⣿

ϵͳÿÌì²úÉúÒ»¸öexcelÎļþ£¬¸ñʽÏàͬ£¬ÄÚÈÝÓÃÎļþÃû£¨ÓòúÉúµÄʱ¼äÃüÃû£©Çø·Ö¡£ÎÒ×öÁËÒ»¸öaccessÊý¾Ý¿â£¬µ¼ÈëexcelµÄÊý¾Ý£¬ÎÒÏë¼ÓÒ»Ïî¼Í¼ÎļþÃûÀ´Çø·ÖÄÚÈÝ£¬¿ÉÊÇÔõô×öÄØ£¿ÓÖ»òÕßÓÃʲôÆäËû·½·¨¿ÉÒÔ°ìµ½£¿Ð»ÁË
Äã ......

Access導³öExecl

VB+Access×öµÄϵ統£¬
Ôõ樣°Ñ數據庫Access內ÈÝ導³öexecl£¿
ÏÖÔÚû¶«Î÷ÊÔ£¬´ÓÍøÉÏÕÒÁ˶δúÂëÄã¿´¿´
VB code:

Private Sub ExportOneTable()
'EXPORTS TABLE IN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ