Access OpenConnection for mdb file RRS feed

  • Question

  • I am trying to establish an ADO connection from an Access (2003) project to an Access (2003) mdb datbase as the 'base' connection - that is, by using the OpenConnection method of the CurrentProject.Connection

    I have no difficulty establishing a connection to the mdb if I create a connection object within code. I have no difficulty using the OpenConnection method to create a connection to a SQL database. But every time (using all of the combinations for ConnectionString that I can think of) I try to use the OpenConnection with an mdb file as the target I get the error:

    Method 'OpenConnection' of object '_CurrentProject failed - -2147467259(80004005)

    Has anybody actually been able to do what I am trying to do? If so, can you show me the connection string that worked for you?



    Thursday, April 8, 2010 5:15 PM