connectionstring

Hi I have two excel files stored in Dropbox - one a database that is not opened by users and the other a tool that runs two query tables from the database and is supposed to refresh the query tables on auto_open by setting the connectionstring to the users filepath to find the data source -...

I have the following code which errors as given below. Calling line is Call ObtainPremiumSummaryData("3000724", #1/7/2017#, #1/7/2016#) Public Sub ObtainPremiumSummaryData(strCustNo As String, dteClaimYearStart As Date, dtePreviousYearStart As Date) Dim cnn As New ADODB.Connection...

I am trying to open a database in excel vba. I started a macro and chose Get External Data from Microsoft Query. That populated a column with data but what I want is a database object I can use to create recordsets such as db.OpenRecordset(sMySqlString, dbOpenDynaset). The macro created this...

Hi all, I have a few Pivot tables which are connected to some Access queries. I would like to know if the connectionstring is correct? Environment: Windows 7 Access 2010 - multi user database Excel 2010 - multi user file Here are an example of a connectionstring...

Hello I've followed the MSN brief on my problem as best I can, but still have issues! I understand why it does it and why it happens, but can't seem to set my RecordSet and preserve optimistic locktype and dynamic cursor. If I understood it (probably not) correctly, I need to Open the...

Current Connection String is as follows: DSN=MS Access Database;DBQ=C:\Needs Based Budget\NBB00_13-14.accdb;DefaultDir=C:\Needs Based Budget;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5; I have an application consisting of an excel 2007 workbook and access 2007 database. I...

I connect to an Oracle database by the code below. Is it possible to improve the code? What could a function which returns data based on a ID in a Excel sheet look like =getName(id)? Is it bad syntax to make a function with a sql string-parameter like =getValue("SELECT * FROM db WHERE Id = id")...