如何使用C#激活以前打開的應用程式的microsoftaccess實體？

我正在使用此代碼打開訪問資料庫：

public partial class Start_Baseet : System.Windows.Forms.Form
{
string MyFile = Environment.CurrentDirectory   "\\Baseet.accde";
Microsoft.Office.Interop.Access.Application AccApp = new Microsoft.Office.Interop.Access.Application();

public Start_Baseet()
{
    InitializeComponent();
}
public void OpenDb()
{
  
        AccApp.Visible = true;
        AccApp.OpenCurrentDatabase(MyFile, false, "017014a");
        AccApp.RunCommand(AcCommand.acCmdAppMaximize);
        // AccApp.Activate();


    }
}
      

private void Start_Basset_Load(object sender, EventArgs e)
{
    try
    {
        OpenDb();
    }
    catch
    {
        AccApp.Quit();
        MessageBox.Show("Something is missing", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
    }
    finally
    {
        this.Close();
        System.Windows.Forms.Application.Exit();
        System.Windows.Forms.Application.ExitThread();
        // Process.GetCurrentProcess().CloseMainWindow();
    }

問題是MSACCESS行程在正在運行的行程中堆積，所以我嘗試了這個：

  //var prc = Process.GetProcessesByName("MSACCESS.EXE*32");
        var prc = Process.GetProcessesByName("Microsoft Access");
        if (prc.Length > 0)
        {
            MessageBox.Show("Access Found");
            SetForegroundWindow(prc[0].MainWindowHandle);
        }
        else
        {
            AccApp.Visible = true;
            AccApp.OpenCurrentDatabase(MyFile, false, "017014a");
            AccApp.RunCommand(AcCommand.acCmdAppMaximize);
            // AccApp.Activate();


        }
    }
    [DllImport("user32.dll")]
    private static extern bool SetForegroundWindow(IntPtr hWnd);

但是每次我使用代碼時，都會MSACCESS啟動另一個行程。我怎樣才能解決這個問題 ？另一點，如果我第二次運行我的應用程式，它將打開同一個資料庫的一個新實體，如果它被打開，我可以激活資料庫，否則打開它的一個新實體？謝謝

uj5u.com熱心網友回復：

嘗試這個。這應該會通過錯誤捕獲來捕獲關閉 Access 的用戶。我確信它可以改進，但是，我沒有從我不久前寫的這段代碼中得到一堆 MSAccess.exe。

public partial class Form1 : Form
{
    Microsoft.Office.Interop.Access.Application accApp = new Microsoft.Office.Interop.Access.Application();
    private bool isFormClosed = false; 

    public Form1()
    {
        InitializeComponent();
        OpenMicrosoftAccessFile(@"FileName");

        Thread t = new Thread(new ThreadStart(CheckIfMSAccessExeIsRunning)); 
        t.Start();
    }

    /// <summary>
    /// The User Closed Out Access Cleanup.
    /// </summary>
    public void CheckIfMSAccessExeIsRunning()
    {
        int secondsToWait = 5*1000;
        while(!isFormClosed)
        {
            if (accApp != null && 
                accApp.Visible == false)
                CloseMicrosoftAccessFile();
            Thread.Sleep(secondsToWait);
        }
        CloseMicrosoftAccessFile();
    }

    private bool OpenMicrosoftAccessFile(string accessFileName)
    {
        try
        {
            if (accApp != null &&
                !accApp.Visible)
            {
                CloseMicrosoftAccessFile();
            }

            if (accApp == null)
            {
                accApp = new Microsoft.Office.Interop.Access.Application();

                accApp.OpenCurrentDatabase(accessFileName);

                accApp.Visible = true;
            }
            return true;
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
            Console.WriteLine((ex.InnerException != null) ? ex.InnerException : "");
            CloseMicrosoftAccessFile();
            return false;
        }
    }

    private void CloseMicrosoftAccessFile()
    {
        try
        {
            if (accApp != null)
            {
                accApp.CloseCurrentDatabase();
                accApp.Quit();
            }
        }
        catch (Exception ex)
        {
            //Good chance there never was an Access exe.
            Console.WriteLine(ex.Message);
            Console.WriteLine((ex.InnerException != null) ? ex.InnerException : "");
        }
        finally
        {

            System.Runtime.InteropServices.Marshal.ReleaseComObject(accApp);
            accApp = null;

        }
    }

    private void Form1_FormClosed(object sender, FormClosedEventArgs e)
    {
        isFormClosed = true;
    }
}

此外，如果您仍然有運行除錯器的行程，或者 Visual Studio 可能仍在保留它。最好從發行版 exe 中對此進行測驗。如果 OpenMicrosoftAccessFile 回傳 false，您可以嘗試再次打開它，但是這樣會忽略它捕獲的錯誤。

標籤：C＃ 毫秒访问

上一篇：MSAccess：對包含附件欄位的多對多關系運行洗掉查詢；從一個按鈕

下一篇：MSAccess查詢-顯示原始連接表中的所有行