Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JPC44
  • Order by date
  1. JPC44

    Excel 2007: OpenDatabase fails to connect to a SQL database

    I have a reference to the Microsoft DAO 3.6 Object Library. Could I be missing other references? But I'd probably get an error message when compiling the add-in. It could be a bug in Excel 2007. This add-in works in earlier versions of excel and works in debug mode in excel 2007. AND if I open...
  2. JPC44

    Excel 2007: OpenDatabase fails to connect to a SQL database

    I have a problem with my excel add-in which works fine for earlier versions of excel - but does not work properly with excel 2007. The OP system is windows XP. The code to connect is as follows: Public cs_dbs As Database Set cs_dbs = OpenDatabase(dbName, False, True, "ODBC;Regional=Yes") When...

Part and Inventory Search

Back
Top