C# ´´½¨AccessÊý¾Ý¿â±í
using System;
using System.IO;
using System.Windows.Forms;
using Access = Microsoft.Office.Interop.Access;
// Ìí¼ÓÒýÓÃ->.NET-> dao£¬Microsoft.Office.Interop.Access
namespace WinFormAccess
{
public partial class FormAccess : Form
{
public FormAccess()
{
InitializeComponent();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
try
{
string dbPath = Path.Combine(Application.StartupPath, "Images.mdb");
if (File.Exists(dbPath))
File.Delete(dbPath);
Access.Application newAccess = new Access.Application();
newAccess.NewCurrentDatabase(dbPath);
dao.Database db = newAccess.CurrentDb();
//db.Execute("create table [Images] (Name String primary key, Bytes LongBinary)", Type.Missing);
db
Ïà¹ØÎĵµ£º
²¿·ÖÂÛ̳ÐÂÊÖÃÇû¾¯Ìè×Ô¼ºÂÛ̳Êý¾Ý¿â´æÔÚµÄΣÏÕ£¬ËùÒÔ»¹ÊÇ ¾ö¶¨ÒÔDvbbs7.0ΪÀý£¬½éÉÜÒ»ÏÂÈçºÎ±£»¤ºÃÄãµÄAccessÊý¾Ý¿â ¡£Ïл°ÐÝ˵£¬ÇëÍùÏ¿´£º
1¡¢¸øÄãµÄAccessÊý¾Ý¿â¼ÓÉÏÃÜÂë±£»¤£¨ÆäʵAccessÊý¾Ý¿â µÄÃÜÂë±£»¤·Ç³£´àÈõ£¬ÕâÀֻÊǸøËû¶à¼ÓÉÏÒ»°ÑËø¶øÒÑ£©¡£
a.´ò¿ªMicroSoft AccessÈí¼þ£¬ÊÇÓöÀÕ¼·½Ê½´ò¿ªÄãµÄDVÂÛ Ì³Êý¾ ......
ÔÚ×öasp.netµÄWeb¿ª·¢µÄʱºò£¬ÎÒÃǾ³£»áÓöµ½Ò»´ÎÐÔÉÏ´«¶à¸öÎļþµÄÐèÇó¡£Í¨³£ÎÒÃǵĽâ¾ö·½·¨Êǹ̶¨·Å¶à¸öÉÏ´«Îļþ¿ò£¬ÕâÑùµÄ½â¾ö°ì·¨ÏÔÈ»ÊDz»ºÏÀíµÄ£¬ÒòΪһ´ÎÉÏ´«¶à¸ö£¬¾ÍÒâζ×ÅÊýÁ¿²»È·¶¨¡£Òò´ËÎÒÃǾÍÒªÈÃÕâЩÎļþÉÏ´«¿ò¶¯Ì¬Ìí¼Ó£¬ÏÂÃæÎÒÒÔÎÒ×öµÄÒ»¸öͼ¿â¹ÜÀíÖеÄÉÏ´«Í¼Æ¬µÄ¹¦ÄÜΪÀý
ÏÈ¿´Ð§¹û£º
´ò¿ªµÄ³õʼ½çÃæ£º
ĬÈÏ ......
½ñÌìÔÚÓÃC#´´½¨AccessÊý¾Ý¿âµÄʱºòÓöµ½ÁËÒ»¸ö×Ö¶ÎÀàÐ͵ÄÎÊÌ⣬ÒòΪ³ÌÐò´´½¨Êý¾Ý¿â±íÕâ¸öÔÚSqlServerÉϱȽϳ£¼û£¬ÔÚ°Ù¶ÈÖÐÕÒÁ˺ܾ㬰ÑÏà¹ØµÄÊôÐԳ¼ÏÂÀ´°É£¬ÒÔ¹©ÒÔºóʹÓá£
1¡¢¶¯Ì¬´´½¨AccessÊý¾Ý¿â£º±¾È˾õµÃÓÃADOXµÄ·½Ê½¼òµ¥ÊǼòµ¥£¬µ«ÊÇ»¹ÊÇÐèÒªÒ»¸öDLL×齨·½¿ÉÒÔʵÏÖÊý¾Ý¿âµÄ´´½¨£¬ËùÒÔÄÇÎÒÃǾͻ»¸ö˼·°É£¬ÎªÊ²Ã´²»¿ ......
ÔÚWin7ϰ²×°ÍêFoxmail6.5£¬Í˳ö³ÌÐò²¢ÖØÐÂÆô¶¯Foxmailºó³öÏÖÈçÏ´íÎó£º
Access violation at address 007CC4B1 in module 'Foxmail.exe'. Read of address 00000014.
µ¼ÖÂFoxmail²»ÄÜÆô¶¯£¬µã»÷È·¶¨ºóÈԻ᲻¶Ï³öÏÖÀàËÆ´íÎóÌáʾ¡£
Õâ¿ÉÄÜÊÇFoxmailÔÚWin7 ......
½ñÌìÔÚVS2005µ÷ÊÔÒ»¸öC# C/S³ÌÐò£¬µ±Í¨¹ýRFCÓëSAPÁ¬½Óʱ¼ä¹ý³¤Ê±£¬³öÏÖ´Ë´íÎó£¬ÔÚÍøÉÏÕÒµ½½â¾ö°ì·¨¡£
VS2008ÉϵÄÒ»¸ö³ÌÐò£¬Í¨¹ýOracle.DataAccess.dllÖ´ÐÐdrop user
cascade²Ù×÷£¬ÎÒÔÚsqlplusÖ´Ðд˲Ù×÷´óÔ¼ÐèÒªÒ»·ÖÖÓ×óÓÒʱ¼ä£¬µ±ÎÒÔÚVS2008ÖÐdebugÆô¶¯´Ë³ÌÐòʱ£¬Ò»Ö±½ÓÊÕµ½
“ContextSwitchDeadlock is detected& ......