Creating Db Connection At Runtime Follow

Legacy Poster

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?


Fernando Ramos Miracle
Comment actions Permalink

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.

Please sign in to leave a comment.