ACC2000: ¸ðµç Å×À̺íÀÇ ¿¹¸¦ AllowZeroLength ¼Ó¼º ¼³Á¤ ¹æ¹ý

±â¼ú ÀÚ·á: 210278 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
º¸Åë: ±âº»ÀûÀÎ ¸ÅÅ©·Î, ÄÚµå ÀÛ¼º ¹× »óÈ£ ¿î¿ë¼º ±â¼úÀÌ ÇÊ¿äÇÕ´Ï´Ù.

ÀÌ ¹®¼­¿¡¼­´Â Microsoft Access µ¥ÀÌÅͺ£À̽º (.mdb) ¿¡¸¸ Àû¿ëµË´Ï´Ù.

¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

¿ä¾à

ÀÌ ¹®¼­¿¡¼­´Â µ¥ÀÌÅͺ£À̽ºÀÇ ¸ðµç Å×ÀÌºí¿¡ ÀÖ´Â ¸ðµç ÅØ½ºÆ® ¹× ¸Þ¸ð Çʵ忡 AllowZeroLength ¼Ó¼ºÀ» ¿¹ ·Î ¼³Á¤ÇÒ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö¸¦ ¸¸µå´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.

Ãß°¡ Á¤º¸

AllowZeroLength ¼Ó¼ºÀ» ¼³Á¤ÇÏ¿© Á¦¾îÇÒ ¼ö ÀÖ´ÂÁö ±æÀ̰¡ 0ÀÎ ¹®ÀÚ¿­ ("") ÅØ½ºÆ® ¹× ¸Þ¸ð Çʵ忡 À¯È¿ÇÑ Ç׸ñÀÔ´Ï´Ù. AllowZeroLength ¼Ó¼ºÀ» ±âº» ¼³Á¤Àº ¾Æ´Ï¿äÀÔ´Ï´Ù . µ¥ÀÌÅͺ£À̽ºÀÇ ¸ðµç Å×ÀÌºí¿¡ ´ëÇØ ¿¹ ·Î AllowZeroLength ¼Ó¼ºÀ» ¼³Á¤ÇÏ·Á¸é ´ÙÀ½ ÀÌ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

ÁÖÀÇ : ÀÌ ¿¹Á¦ÀÇ ´Ü°è¸¦ ¼öÇàÇÑ °æ¿ì Northwind.mdb ¿¹Á¦ µ¥ÀÌÅͺ£À̽º¸¦ ¼öÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. Northwind.mdb ÆÄÀÏÀ» ¹é¾÷ÇÏ°í µ¥ÀÌÅͺ£À̽º º¹»çº»¿¡ ÇϽʽÿÀ ÇÒ ¼ö ÀÖ½À´Ï´Ù.

Âü°í : ÀÌ ¹®¼­ÀÇ ¿¹Á¦ ÄÚµå´Â Microsoft DAO¸¦ »ç¿ëÇÕ´Ï´Ù. ÀÌ Äڵ带 Á¦´ë·Î ½ÇÇàÇÏ·Á¸é Microsoft DAO 3.6 °³Ã¼ ¶óÀ̺귯¸®¿¡ ÂüÁ¶ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é Visual Basic Editor¿¡¼­ µµ±¸ ¸Þ´ºÀÇ ÂüÁ¶ Ŭ¸¯Çϰí Microsoft DAO 3.6 °³Ã¼ ¶óÀ̺귯¸®¿¡ È®ÀζõÀÌ ¼±ÅõǾî ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù.

  1. Microsoft Access¸¦ ½ÃÀÛÇϰí Northwind.mdb ¿¹Á¦ µ¥ÀÌÅͺ£À̽º¸¦ ¿±´Ï´Ù.
  2. ¸ðµâÀ» ¸¸µé°í ¼±¾ð ±¸¿ª¿¡ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÑ ÀÖÁö ¾ÊÀ¸¸é ÀÌ¹Ì ÀÖ½À´Ï´Ù.
    ¸í½ÃÀû ¿É¼Ç
  3. ÀÔ·ÂÇϰųª ´ÙÀ½ ÇÁ·Î½ÃÀú¸¦ ºÙ¿©:
    Function SetAllowZeroLength ()
        Dim I As Integer, J As Integer
        Dim db As DAO.Database, td As TableDef, fld As Field
    
        Set db = CurrentDB()
        'The following line prevents the code from stopping if you do not
        'have permissions to modify particular tables, such as system
        'tables.
        On Error Resume Next
        For I = 0 To db.TableDefs.Count - 1
           Set td = db(I)
           For J = 0 To td.Fields.Count - 1
              Set fld = td(J)
              If (fld.Type = DB_TEXT Or fld.Type = DB_MEMO) And Not _
                fld.AllowZeroLength Then
                 fld.AllowZeroLength = True
              End If
           Next J
        Next I
        db.Close
    End Function
    					
  4. ÇÔ¼ö¸¦ Å×½ºÆ®ÇÏ·Á¸é Á÷Á¢ ½ÇÇà â¿¡ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÑ Enter ۸¦ ´©¸¨´Ï´Ù.
    ? SetAllowZeroLength()
    ¸î ÃÊ ÈÄ Âü°í AllowZeroLength ¼Ó¼ºÀÌ º¯°æµË´Ï´Ù ¿¹ µ¥ÀÌÅͺ£À̽ºÀÇ ¸ðµç Å×ÀÌºí¿¡ ÀÖ´Â ¸ðµç ÅØ½ºÆ® ¹× ¸Þ¸ð Çʵ忡.
Âü°í : º¯°æÇÏ¿© ÇØ´ç If... ´ÙÀ½ ¶ÇÇÑ ´ÙÀ½ ÇÊµå ¼Ó¼ºÀ» ¼öÁ¤ÇÒ Å×À̺íÀ» ¹Ýº¹ ¼ö Á¶°Ç°ú À§ÀÇ ÄÚµå ¹Ù·Î µÚ¿¡ ¹èÁ¤: À̸§ , ValidationRule , ValidationText , ÇÊ¿äÇÑ ¹× DefaultValue .

ÂüÁ¶

AllowZeroLength ¼Ó¼º¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº µµ¿ò¸» ¸Þ´º¿¡¼­ Microsoft Access µµ¿ò¸» À» Ŭ¸¯ÇÕ´Ï´Ù Office ±æÀâÀ̳ª µµ¿ò¸» ¸¶¹ý»ç¿¡¼­ allowzerolength ¼Ó¼º À» ÀÔ·ÂÇÑ ´ÙÀ½ °Ë»ö Ç׸ñÀ» º¾´Ï´Ù.

¼Ó¼º

±â¼ú ÀÚ·á: 210278 - ¸¶Áö¸· °ËÅä: 2005³â 1¿ù 26ÀÏ ¼ö¿äÀÏ - ¼öÁ¤: 2.1
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Access 2000 Standard Edition
Ű¿öµå:?
kbmt kbhowto kbinfo kbprogramming KB210278 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â