To connect ms access database without alias

• muk07

  Old Hand

  Points: 367

  More actions

  May 15, 2004 at 5:40 am

  #179644

  How can I connect to MS ACCESS database without using alias (CBuilder, BDE).

  I write:

  db->DriverName="MSACCESS";

  db->Params->Add("DATABASE NAME=c:\mybase.mdb");

  Got a failure.

  When I did so with MS SQL Server base, I had success.

• May 18, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Richard Binnington

  SSChasing Mays

  Points: 626

  More actions

  May 18, 2004 at 4:08 pm

  #506869

  I believe you can tell Access that the default driver is Access by putting a semicolon in front of the connect string.

      Dim tdfLinked As TableDef        

      Set tdfLinked = dbsTemp.CreateTableDef("Table")

      tdfLinked.Connect = ";Database=c:\mybase.mdb"

      tdfLinked.SourceTableName = "TableName"

      CurrentDb.TableDefs.Append tdfLinked

  Richard