C#Á¬½ÓAccessÊý¾Ýʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ßд³Édbo.xxxTable£¬ËùÒÔÈç¹ûÄãÒªÊÇÒ²ÔÚAccessÖÐÕâÑùдµÄ»°£¬¾Í»á±¨ÈçÉÏÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£ÐÞ¸ÄSQLÓï¾ä£¬È¥µôdboºó£¬ÎÊÌâ½â¾ö¡£
Ïà¹ØÎĵµ£º
Îı¾ nvarchar(n)
±¸×¢ ntext
Êý×Ö(³¤ÕûÐÍ) int
Êý×Ö(ÕûÐÍ) smallint
Êý×Ö(µ¥¾«¶È) real
Êý×Ö(Ë«¾«¶È) float
Êý×Ö(×Ö½Ú) tinyint
»õ±Ò money
ÈÕÆÚ smalldatetime
²¼¶û bit
¸½£º×ª»»³ÉSQLµÄ½Å±¾¡£
ALTER TABLE tb ALTER COLUMN aa Byte Êý×Ö[×Ö½Ú]
ALTER TABLE tb ALTER COLUMN aa Long Êý×Ö[³¤ÕûÐÍ]
ALTER T ......
MicrosoftµÄACCESSÊý¾Ý¿â£¬ÊÇÎÒÃdz£ÓõÄ×ÀÃæÊý¾ÝÖ®Ò»£¬´ó¶àÖÐСÆóÒµµÄÊý¾Ý¿â¹ÜÀíϵͳ¶¼¿ÉÒÔ²ÉÓÃËü£¬µ«Æä°²È«ÐÔÒ»Ö±ÁîÈ˵£ÓÌ£¬ÊÔÏ룬һÌײÆÎñ¹ÜÀíϵͳ£¬Óû§Ö±½Ó´ò¿ªÊý¾Ý¿âÈ¥¸ü¸ÄÊý¾Ý£¬ºó¹û»áÈçºÎ£¿ÓÐЩϵͳ¶ÔACCESSÊý¾Ý¿â¿ÉÄÜÖ»ÊǸü¸ÄÀ©Õ¹Ãû£¬»ò¼Ó¸öÃÜÂ룬ÖÚËùÖÜÖª£¬ÆÆ½âACCESSÃÜÂëµÄ·½·¨ºÍ¹¤¾ßÍøÉ϶àµÄÊÇ£¡ËùÒÔÕâÑùµÄ¼Óà ......
Data Source=sqlservername;Initial Catalog=dbname;User ID=userid;Password=userpwd
Data Source=(local)\\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;User ID=ÕʺÅ;Password=ÕʺÅÃÜÂë
Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\ ......