acewang的专栏

---比如有a、b两台机子，在a机上有access数据库，共享在//a//exam//水位.mdb 。 现在在b机编写程序访问之。conn = new OleDbConnection();conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=//a//exam//水位.mdb ";conn.Open();---

using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; ? using SQLDMO; ? namespace TestSQLDMO { ?????? /// ?????? //

samples:string connStr="PWD=;SourceType=DBF;UID=;Collate=Machine;Deleted=Yes;BackgroundFetch=Yes;Exclusive=No;Driver=Microsoft Visual FoxPro Driver;Null=Yes;SourceDB=h://";   OdbcConnection conn=new O

HOW TO: Create an Access Database Using ADOX and Visual C# .NEThttp://support.microsoft.com/default.aspx?scid=kb;EN-US;317881

引用Microsoft Jet and Rel.........,dll名为msjro.dll ... 然后using JRO; JetEngine x = new JetEngine(); x.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e://db.mdb;Jet OLEDB:Database Password=1