Search results

  1. J

    Could not start transaction; too many nested transaction

    Hi, I have written a whole lot of VBA code that extracts data from bloomberg and inserts it into my database that I have created in Access. The problem is that when I try to run my code I always get this error message: Could not start transaction; too many nested transaction and then access...
  2. J

    Selecting 2 different fields in the same table with different criteria

    Hi, Say for example I have a table with 3 fields: Date, Sector, Weight Is it possible for me in the one SQL statement to select the sector field with one set of criteria and the weight field with another set of criteria? ie is it possible to combine the following 2 SQL statements into 1...
  3. J

    Connection String Question

    Hi, I have an Excel addin that uses an ADODB.connection object to connect to an Access 2007 database that resides on a network drive. The connection string I am using is here: cnFMDB.Open "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = " & strFMDB where cnFMDB is my connection object and...
Back
Top Bottom