none
Need to know how to access System.Data.OleDb.OleDbConnection class RRS feed

  • Question

  • Working on an Access project in VBA, I need to use the class System.Data.OleDb.OleDbConnection, but can't find it. I've looked in the Tools | Reference list box, but can't find anything obvious which would enable access to this class. Any ideas on how I get this loaded? Thanks.
    Wednesday, July 28, 2010 5:07 PM

Answers

  • Actually, I misread your question. Access is not a .NET application so it would not be able to reference .NET libraries. For Access you would use either the DAO or ADO COM libraries.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, July 29, 2010 1:37 AM

All replies

  • It's part of the System.Data namespace which should already be included in your project (see your References list).

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, July 28, 2010 6:50 PM
  • Actually, I misread your question. Access is not a .NET application so it would not be able to reference .NET libraries. For Access you would use either the DAO or ADO COM libraries.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, July 29, 2010 1:37 AM