Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Öн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ

ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ.
ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%,
ÔÙÔÚ²é詢 ......

accessÖÐreplaceÎÊÌâ

ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
  ID              UnistsName
  UN1            ºÚÁú½­¶«·½Ñ§Ôº
  UN2      ......

Access´ø²ÎÊýµÄ²éѯ

ÔÚaccessÖÐÔõôִÐÐselect TOP (@size) * from table1
Õâ¸öTOPÔõô´ø²ÎÊý²éѯ°¡
ÓÃVBA¶¯Ì¬Éú³ÉSQLÓï¾ä£¬ÔÙÖ´ÐÐ

²»ÄÜÖ±½ÓÓÃSQLÓï¾ä£¬ÓÃ×Ö·û´®ÀÛ¼ÓÉú³ÉSQLÓï¾äµÄ·½·¨À´Ö´ÐÐSQLÓï¾ä

top n Õâ¸öûÓа취ʹÓò ......

ÈçºÎΪaccessÊý¾Ý¿â¼ÓÃÜ

¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º

£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ

       

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