C#

    public class FileOrganizer<br />
    {<br />
        private static Form1 mainForm;<br />
<br />
<br />
        [STAThread]<br />
        static void Main()<br />
        {<br />
            Application.EnableVisualStyles();<br />
            Application.SetCompatibleTextRenderingDefault(false);<br />
            mainForm = new Form1();<br />
            Application.Run(mainForm);<br />
        }

venkatcontact wrote:

desperately in need

Planker wrote:

Is there a way I can open the DB with out locking the DB for any other write access

Dave Kreskowiak wrote:

explanation was that he couldn't open the database in Access and still have database writes be made by his application.

System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\...\db1.mdb";
connection.Open();
System.Data.OleDb.OleDbCommand command = connection.CreateCommand();
System.Data.OleDb.OleDbTransaction transaction = connection.BeginTransaction();
command.Transaction = transaction;
command.CommandText = "INSERT INTO Table1 (Field1) VALUES ('A')";
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO Table1 (Field1) VALUES ('B')";
command.ExecuteNonQuery();
// Breakpoint here
transaction.Commit();