Creating Db Connection At Runtime 追蹤


I use Access and Bartender in many of my Excel macros. I am able to build a connection string for the Access db  based upon the workbook path. For example:


 ConnStrg = "provider=microsoft.ACE.OLEDB.12.0;data source=" & ThisWorkbook.Path
    ConnStrg = ConnStrg & "\ReorderDB.accdb;persist security info=false;"


I would like to do the same for Bartender, that is create the format database connection at runtime.  Any suggestions?

1 意見

Fernando Ramos Miracle
評論操作 永久連結

Although we strongly recommend using the built in database connection setup directly supported by BarTender you could always built the connection using a VB script. Note that in this case you would need to use script to load the information on each of your document's objects.


Also note that you could always create a join in BarTender between different databases instead of needed to custom make the required database connection.


*In any case, I'm attaching a simple example we built some time ago that uses a script in the Data Entry Form to query a database and load its data to the label objects. The script does the following:


1.       Fills a drop down list from an Excel spreadsheet.


2.       Uses the choice selected in the drop down list to query the database again to retrieve records that match the selection.