Access Vba Odbc Connection String

The problem is your connection string. I have some queries which are saved queries, yet sometimes I want to change the ODBC Connection String without having to manually open each of the queries in design mode to change the string. Finding it hard to remember database connection strings? Everybody does! Here is an easy-to-use reference of connection. Hope that helps. I know that I'm almost there, but I did not declare a variable named Conn, and I have no experience with setting the connection/database in this way, so I'm stumbling around a bit. You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. VBA, ODBC Authentication, and Passthroughs but I have a reporting box that kicks off 20 to 30 access databases a day. Sometimes I'll start a project using an Access backend, with the intent of moving it to a SQL Server later. 0 Library reference is required to run this code Sub ReadFromExcel() ' Dim strConString As String Dim strQuery As String Dim objCon As ADODB. Select the File DSN tab and click Add. Need to Connect to Oracle DB with no ODBC. The correct call is to specify empty string as connection name. Also included are ADO. 09/21/2018; 2 minutes to read +1; In this article. Various SQL database connection strings and database connection scrpting examples. Do you suspect those connection string variations cause or contribute to your Access database issues? If so, you could standardize them and check what impact that change has on the other issues. ODBC Connection String - Microsoft Community. You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. For MS Access Database connection strings, you MUST use the DSN-less OLEDB driver. This procedure looks through all the tables in the Access database, and sets the connection string for every ODBC table to the one defined in. So it is possible to do it programtically without ODBC? Could anyone advise? Thanks a lot. NET Framework is supported the ODBC Data Provider. In the dual-database. I have got stumped at the very first hurdle. Is there an ODBC connection string to enable or disable this option from a program?. MySQL Connector/ODBC Developer Guide. Posts tagged ‘connect oracle database via excel vba’ Excel Macro: Connecting to Oracle Database In the previous post, Risnardi mentioned that Excel can be connected to database to serve various purposes. 'Use a Function to get the Connection string 'Note: I never use "Connection" in the names of my Variables or Procedures. Access 2010 includes an option checkbox "Open databases by using record-level locking" (under Client Settings). Lost connection to MySQL server during query (#2013)". access a text file using the ODBC the text ODBC driver in the connection string. Same is true for a 32-bit process also. odbc connection vba | refresh odbc connection vba | vba odbc connection | excel odbc connection vba | create odbc connection vba | connection string odbc vba |. NET Tutorial and source code VB. In the Access application a screen is used to consult/adapt the MySQL database data in Access. Note that you mentioned UID, password, etc. Configuring JDBC/ODBC Drivers. We will use OLEDB for our example as it's faster and more stable. EXE program. In this Article, I am going to teach you, how you can do a connection with a SQL Server. This is a new link and instead of going to 150 user pc's and creating an ODBC connection manually, I would like to create the connection in the Main form of my Access Database. The first step is to create an ODBC connection to your external database. SQL/Server ODBC Database Connection Method Example. Connection strings for Access 2010. Will any of the above work with a 2013 Runtime version to be sent to a client where I am not aware of the server name or path?. The connection uses an ODBC datasource and creates an Oracle dataadapter. Then you can create DSN for ODBC in your code. The examples that this article contains apply to Microsoft Office Access 2007, to Microsoft Office Access 2003, and to Microsoft Access 2002. Connection to Database. This installs the SQLite ODBC driver and creates a System DSN. Connection String - Free download as Text File (. Connection Dim server_name As String Dim database_name As String Dim user_id As String Dim password As String ' Table action variables Dim i As Long ' counter Dim sqlstr As String ' SQL to perform various actions Dim table1 As String, table2 As String Dim field1 As String, field2 As String. I assume PB also can use ODBC and then you wont need oracle client which supports native connections. Never fear, for PHP can easily work with Access databases using an ODBC driver. Change Excel OLEdb Connection to Access Database vba Excel VBA to Extract Data from an Access Database. through a. Excel VBA Notes for Professionals - books. My code is as follows:. Recordset is just a temporary table in memory that. Describes how to create an SQL pass-through queries in Access which are used to send commands directly to an ODBC database server instead of having the Microsoft Jet database engine process the data. Typically, you use file data sources (also called DSN files) to add a connection string, in which case, the FILEDSN keyword is used on the connection string, or stored in the registry, in which case. Connect to current database. Dim objFSO. By passing the ODBC Data source name and optionally user-id and password to the Connection Object's Open() method. MS Access 2003: Configure ODBC Login. Dim cn As ADODB. I figured I would just have the macro write the connection string at the same time it sends the new CommandText, but I'm running into errors. Thank you for your help. 0 Object Library Microsoft DAO 3. Thank you for your help. Connect using Microsoft. When the ODBCConnectStr property is set to "ODBC;", Microsoft Access will prompt you for a connection string whenever the query is used but won't store the connect string. DSN connections can be used with a Microsoft Access databases and other ODBC compliant databases. Microsoft Access Split Databases: Connection Strings Then we will use VBA to fix those connection strings. Thank and regards, Abdul Haseeb. Click Connections > Relational. Describes how to create an SQL pass-through queries in Access which are used to send commands directly to an ODBC database server instead of having the Microsoft Jet database engine process the data. Use VBA to get the correct number of records in a Recordset object. net OdbcConnection will just pass on the connection string to the specified ODBC driver. CMS Supervisor ODBC and JDBC Data Connection Documentation - Free download as PDF File (. Discovering the Connection String To find out the connection string specific to your database vendor and configuration, use the Windows ODBC Data Source Administrator: On a typical client PC, open Control Panel -> Administrative Tools -> Data Sources. org (OOo) is able to read and write from a wide variety of databases, as long as they support one of the standard interface specifications such as ODBC or JDBC. Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server. Without a connection string, you would be required to store or pass a complex array of structures to access data. 0, Microsoft Access accdb ODBC Driver, OleDbConnection and ODBC. Database Connectionstrings. CreateObject("ADODB. To remove the driver use the start menu entries or the UNINST. It makes switching from Access to SQL Server a breeze. I can also access the connection string of my current linked tables, by watching "CurrentDb. In the Access application a screen is used to consult/adapt the MySQL database data in Access. You can also define a connection string in your code that specifies the connection information. This MSAccess tutorial explains how to configure an ODBC Login with a pass-through query in Access 2003 (with screenshots and step-by-step instructions). TableDefs 'Verify the table is an ODBC linked table. 09/21/2018; 2 minutes to read +1; In this article. Follow these steps:. Now all clients will ‘automagically’ work. TableDef […]. I don’t think connection strings are all that complicated but I often see developers have problems because they simply cloned an existing connection string (or found one on the internet) and tweaked it for the task at hand without really understanding what the keywords and values mean. When the ODBC login window appears, enter your password and click on the OK button. Thank you for your reply. I therefore wrote a routine on startup that creates a temporary database and then copies the structure of the temporary tables into that. ADO directly supports five arguments in a connection string. You may have to register before you can post: click the register link above to proceed. Dim rs As ADODB. Access front end machine (ie. NET Framework. In Access 2003, I have tables linked from an SQL source. 2 * don't statically buffer result of localeconv() * increased some internal string buffers * fixes in SQLSetPos. When the ODBC login window appears, enter your password and click on the OK button. Using VBA we can do this!. NET Framework 2. Same is true for a 32-bit process also. For some applications, you might need to use a connection string to connect to your data source. The problem is the database can link to one of two MySQL databases. It is possible to create a connection string to a Progress database to avoid using an ODBC DSN (Data Source Name). Iguana supports some databases, such as MySQL and Oracle, through their native interfaces (i. ODBC stands for Open Database Connectivity, the industry standard for database C APIs. Each table refer to a specific sheet. Thank you for your reply. Then, it displays the ODBC connection dialogue. To connect to the database, you must supply this information in the connection string. net Odbc Connection will just pass on the connection string to the specified ODBC driver. In this article we will use VBA to retrieve and display the connection strings for the linked tables in a front-end database. dsn on my desktop. Get the connection string online. When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). 1, your connection string could be as follows:. In Access 2003, I have tables linked from an SQL source. This is will be very usefully. Code Include "Driver={Microsoft ODBC Driver for Oracle}" in the connection string to use this driver. You have any questions about IBProvider or Firebird and Interbase driver access? Post your message here! Skip to content. Dim objFSO. Executing SQL Statements in VBA Code By Danny Lesandrini There are a number of ways to execute a SQL Data Manipulation Language (DML) statement from Microsoft Access , besides the obvious process of creating an Action Query and double-clicking its icon. Is there any way to create a linked table in Access using an ODBC connection string instead of a DSN? I can see the connection string when I hover over a linked table that's been created by using a DSN but I can't seem to find a way of modifying or replacing it. Often I find myself with data in an external database, such as Access and continuously editing the query there to get the data how I want it in Excel. Select the appropriate driver (e. having much luck, so I would like to see the format of a connection string with user and password information. Devart ODBC Driver for SQLite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQLite databases from Windows, both 32-bit and 64-bit. NET DataSet. ODBC stands for Open Database Connectivity, the industry standard for database C APIs. ADO File-DSN Database Connection String. There are many connection string examples are available in Internet, so if you cannot find the corresponding example for your database type in this topic, please try to search there. I know this question is already been raised on this forum, but it's never been answered. Get the connection string online. The ASP connection example above is very simple and all you need to do is to create a DSN for your MS Access database. I know this is possible with an ADO connection, I am not sure of how to setup my code to access my sql database. Access Database connection string is different for Access 2003 (*. In this type of connection, you specify all necessary information (the driver, the server, the database name, and the user ID) in the connection string. Hi All, I have a question, I have set up a ODBC connection using the ODBC administrator in MSACCESS to link to an Oracle database on a network server, which wor VERIFY ODBC CONNECTION - Microsoft: Access Modules (VBA Coding) - Tek-Tips. This is the home page of UCanAccess, an open-source Java JDBC driver implementation that allows Java developers and JDBC client programs (e. strConnection = GetCnnString() 'Loop through the TableDefs Collection. It asks again. All I had to do was to copy the string into my porogram. 7 on FreeVBCode. Often I find myself with data in an external database, such as Access and continuously editing the query there to get the data how I want it in Excel. OdbcException: NO_DATA. Now, before we start doing interesting things with the ACE drivers, I ought to explain a bit about their connection strings. When a query is requested on a table within Access, ODBC is used to execute the queries on the MySQL database. ODBC Connection string. NET Forums / Data Access / ADO. 0, Microsoft. x DSN on Windows, use either the ODBC Data Source Administrator GUI, or the command-line tool myodbc-installer. A Connection String is a special string that describes information about a data source (like a Database, but equally it could be a data file, spreadsheet or something else) and also how to connect to said data source. Is there any source of information that can help solving this issue? Looking forward to hearing from you, as I am almost giving up. Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store. 2 * don't statically buffer result of localeconv() * increased some internal string buffers * fixes in SQLSetPos. accdb) because Drivers are different for both the databases. I can connect to database using dsn without username and password but I can't connect if I give the same settings in the connection string. Using an ODBC source for authentication can be critical to some implementation plans; however, actually finding the correct strings and syntax to use can be challenging. I figured I would just have the macro write the connection string at the same time it sends the new CommandText, but I'm running into errors. 1: How to use ADODB. Connect String to Access DSN Connect String to OLEDB Provider for Jet. I was using Provider=Microsoft. As the query refreshes, it nevertheless asks for the password. Standard Security: <% 'declare the variable that will hold the connection string. I'm understand you right? Could you create a sample encrypted database and send it (with "key") to me on ibprovider@ibprovider. ODBC Connection String I have one Windows 7 computer with Nortons 360, connected using a network cable - I have an Access VBA form which as a ODBC connection string to connect to our SQL 2000 server - but it does not connect, it times out, however if I VPN into the office the program works fine. The app prompts the user for name and password, etc. The following examples provide methods to connect to Microsoft Access, Excel, or to Microsoft SQL databases using ODBC connection strings. Download Oracle 11g Release 2 Client ODBC Drivers; Formating Rules for Connection Strings; Connection Strings Explained; Store Connection String in Web. ODBC Connection string. But I don't want to set up DSN in each computer. ADO Example. For some applications, you might need to use a connection string to connect to your data source. When using SQL Native Access Client SQL OLE DB, the application intent connection string should be specified with a space: 'Application Intent' When connecting using SQLClient or ODBC specify 'ApplicationIntent' with no. Windows 7 x64. You can also create an OleDb connection string at run time by using the OleDbConnectionStringBuilder class. Hope that helps. The more specific connection string that specifies a server address works when entered manually, but will get overwritten anytime the macro is run. ODBC connection string to disable record level locking. Various SQL database connection strings and database connection scrpting examples. NET, OLE DB. It was so simple and strings I was trying to use were so close to this one, but still not exact and not correct. Using an ODBC source for authentication can be critical to some implementation plans; however, actually finding the correct strings and syntax to use can be challenging. When we do so, we are presented with the following window. In short, you create a DSN less ODBC connection via a macro. Dim objSource. So why not just make the connection string read-only? Fortunately, you can edit the connection string right there in the Connection Properties dialog. Hi, In my application the user enters password information in a form and this is passed into the ODBC connection string for each query. Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server. Using a Connection String. (Advanced Programming In Access 2013) Creating An ODBC Connection To SQL Server. DO NOT USE ODBC (DSN or DSN-less) for MS Access! Example of DSN Connection: MS SQL / MySQL / PostgreSQL "DSN=dsnname" The DSN itself can be created / configured through the control panel - ODBC section. once when we upgrade to Access 2016 this provider is not working. Hi Everybody I am trying to connect to an Oracle database using Excel VBA (using the ADO objects). It is legal to open ADO connections using ODBC but the downside is that you end up going through more layers because you’d be using OLEDB provider for ODBC to connect with the ODBC driver 17 for SQL Server. When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). not through ODBC). So you can have a minimal Connect string in A2000: ODBC;DSN=ProductionSystem;DATABASE=ProductionDB Thanks-Tom. Open Registry Editor. As the query refreshes, it nevertheless asks for the password. 0 Library reference is required to run this code Sub ReadFromExcel() ' Dim strConString As String Dim strQuery As String Dim objCon As ADODB. Standard Connection String Format¶. The connection uses an ODBC datasource and creates an Oracle dataadapter. I tried establishing connection to DB2 using ADO objects. This example shows you how to construct the connection string to do this using the native OLE DB providers for SQL Server and Access, which are faster than their ODBC counterparts. Replace a complex connection string with a DSN? data source for an Open Data Base Connectivity are "Automating Microsoft Access 2003 with VBA," "Upgrader's Guide to Microsoft Office System. Does anyone have some sample code relatin. If you have properly configured DSN for ODBC (test DSN is OK), that connection string with just DSN=name_of_DSN should work (that is described also in administrator documentation for SyBase). The code below lets you create a connection object by calling the checkdbconnect_net function, which you can keep in a module. Another way is to create a blank txt file, save it, change the extension to. ADO Example. In this case, the required behavior can be explicitly specified in the Connection String by setting the ODBC Behavior parameter. I was using Provider=Microsoft. accdb files. This parameter is available starting with MariaDB Connector/ODBC version 3. Modify a connection string in a odbc connection using excel VBA I am trying to create a script that will change the user name and password in an existing ODBC connection string based on values collected from a user. In this Article, I am going to teach you, how you can do a connection with a SQL Server. When the connection is established , SQL Commands may be executed, with the help of the Connection Object, to. I know that I'm almost there, but I did not declare a variable named Conn, and I have no experience with setting the connection/database in this way, so I'm stumbling around a bit. Les points traités sont la création de sources de données ODBC (DSN), de tables liées ODBC, de requêtes SQL-Direct, et l'utilisation de recordsets DAO avec des connexions OD. All I had to do was to copy the string into my porogram. It provides access to native ODBC drivers the same way that the OLE DB. credentials hard-coded in the ODBC connection string. Unfortunately, the user ID and password are not saved encrypted; they are available for all to see in clear text. It work perfectly if i hardcode the provider string with username and. Microsoft Office. How to Escape Quoted Strings for SQL Statement used in Database via Excel VBA SQL Server uses pairs of single quotes to identify the start and end of a string. To change query timeout value in Registry, follow these steps: Open Registry Editor. First Thread: [[I have a User DSN set up through the ODBC Data Source Administrator, which points to a default database on SQL server. Connector/ODBC Connection Parameters Using Connector/ODBC with Microsoft Access. NET Framework 2. May be, you will need to modify them to adapt for your needs or depending on version of Microsoft Data Access Components (MDAC) installed. The ConnectionString can be set only when the connection is closed, and as soon as it is set it is passed, unchanged, to the Driver Manager and the underlying driver. A connection string can be pasted into the EDT Data Source connection string text box as highlighted below. The methods for setting the parameters are different depending on the environment in which the driver is installed. This article describes a VBA function that will Create DSN For ODBC. Now all clients will ‘automagically’ work. Get Microsoft Access / VBA help and support on Bytes. This class makes it easy to work with multiple linked table objects without having to open and close the database each time. NET Forums / Data Access / ADO. But after a few seconds system mentions "ODBC - call failed. Depending on the SNAC protocol you are using there is a slight variation in the application intent connection string property. Option Explicit Sub CreatePolicyTable() Dim qryTable As QueryTable Dim rngDestination As Range Dim strConnection As String Dim strSQL As String Dim strParam1 As String Dim strParam3 As String Worksheets("Pol Data"). When using ODBC to talk to the AS/400, you can use a data source name to connect or you can use a connection string with all of the relevant settings in the string you pass to the ODBC Driver. Heya, In VBA does anyone know how to use a variable in a SQL connection string? We're aiming for active directory integrated login for SQL that works great, just hoping to prefill thei username field. This is also known as a DSN-less connection. All my tables in Access are linked to this database, and I use the same Access application whether I'm running against Dev or Stage or Prod, by simply changing the SERVER reference in my User DSN. Connection String to Access database : Microsoft Jet « Access « VBA / Excel / Access / Word Dim rs As ADODB. but that example. , thanks Andre Mikulec for testing * cleanup utf8/unicode conversion functions Tue Dec 01 2016 version 0. 'Create a connection to DB2 database by using the IBM OLE DB provider for DB2 Public Function ConnectOLEDB() As ADODB. 0 and higher. The driver can access local Oracle databases or it can communicate with the network through SQL*Net. I followed crystal's links and installed Microsoft Access Database Engine 2016 (32-bit version in my case). Discovering the Connection String To find out the connection string specific to your database vendor and configuration, use the Windows ODBC Data Source Administrator: On a typical client PC, open Control Panel -> Administrative Tools -> Data Sources. The Database property of a Connection object and the Connection property of a Database object make it easier to change connections to an ODBC data source through the Microsoft Access database engine to use. When you define an ODBC connection, you are providing a connection string. Example setup: 1. Hi AllI have informix DB and I am connecting to the database using ODBC Query tool through DSN connection. Sub ExportTbls() Dim sTblNm As String Dim sTypExprt As String Dim sCnxnStr As String, vStTime As Variant Dim db As Database, tbldef As DAO. Connection String Basics, VBA to Teradata SQL Assistant I'm trying to write VBA code that will allow me to run a macro in Microsoft Excel 2007 that connects to Teradata SQL assistant (version 13. Hi, I cannot figure out how to create connection with VBA and ODBC to SQL db. The examples that this article contains apply to Microsoft Office Access 2007, to Microsoft Office Access 2003, and to Microsoft Access 2002. This example shows you how to construct the connection string to do this using the native OLE DB providers for SQL Server and Access, which are faster than their ODBC counterparts. So why not just make the connection string read-only? Fortunately, you can edit the connection string right there in the Connection Properties dialog. Connection strings have been around a long time. Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue; See the respective ODBC driver's connection strings options. Where xxx and yyy represent the estimated amount of time it will take to process the query and the OS/400 query time limit, respectively. Fortunately, Microsoft Access (MS-Access) supports ODBC. You can significantly improve the performance of your Access database by maintaining an open connection to the back-end database throughout the time your front-end database is opened. Describes how to create an SQL pass-through queries in Access which are used to send commands directly to an ODBC database server instead of having the Microsoft Jet database engine process the data. I am thinking of. Connect to a Microsoft Access Database from ASP using DSN-less ODBC connection. Connect String to Access DSN Connect String to OLEDB Provider for Jet. Everything you always wanted to know about ODBC connection strings and the iSeries. Connection String to Access database : Microsoft Jet « Access « VBA / Excel / Access / Word Dim rs As ADODB. I know that I'm almost there, but I did not declare a variable named Conn, and I have no experience with setting the connection/database in this way, so I'm stumbling around a bit. I was using Provider=Microsoft. NET has a lot of similarities to Visual Basic but also some differences. Arguably, this is the most daunting task for casual users, there is no help on how to add the ODBC string to the query and many users may just quit before they even started. ADO directly supports five arguments in a connection string. I am having trouble with the syntax. 0, Microsoft Access accdb ODBC Driver, OleDbConnection and ODBC. By passing a valid Command object into the first argument of a Recordset's Open method. I tried Microsoft. ODBC Connection string. > relinking odbc tables using vba odbc connection string to the DSN or. information in your question, but this info appears nowhere in your code. To fix this problem, the ODBC Driver settings need to be adjusted. Sun ONE ASP for Windows uses standard Windows ODBC drivers, so connection strings you developed for Windows will. I am confused on how to set up my credentials in order to connect and extract data from MS SQL Server using Excel VBA. I have the following connection string defined in the code. ODBC Connection String - Microsoft Community. Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists Scott Excel , Software , VBA May 14, 2014 3 Minutes I’ve been developing a SharePoint team site for my area which will house all kinds of information about the process and tools that I and my team support. Connection String Database Password when used in a connection string from vba to access using the following style: str = "ODBC;DSN=MS Access. 0' provider is not registered on the local machine; Open a password-protected Excel workbook; Formating Rules for Connection Strings; Connection Strings Explained. Connection Dim rs As ADODB. Setting up the spreadsheet as an ODBC Data Source. This article describes how to create a connection to Microsoft SQL Server for linked tables in Microsoft Access that does not use a data source name (DSN). SQLite ODBC Driver ----- Sat Feb 24 2018 version 0. Is that connection possible via ODBC? Is there a driver which works? Thanks for answering my questions!. Connection") oConnection. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a variety of other topics as well. Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. Everything you always wanted to know about ODBC connection strings and the iSeries. Connection Open Method String Example. The Office 365 ODBC Driver is a powerful tool that allows you to connect with live data from Office 365, directly from any applications that support ODBC connectivity. How do I get this SQL Server ODBC Connection working? Server does not exist or access denied. Using a Connection String. The connection string is how ADO (the DB access layer used in ASP) knows how to find your database. This is the snippet Access MySQL databases using ODBC and ADO 2. This works, and allows me to read-write to/from the table while I have the session open. So I am sharing some connection strings to connect to the Microsoft Access database using different drivers. I've a company in the UK using my software, and I find out that the connection string used is named different in the UK. Setting up the spreadsheet as an ODBC Data Source. Does anyone know the connection string syntax to connect to Oracle database, preferably prompting the user to enter the user id and password. How to Create an ODBC Connection. These passthrough queries have an ODBC datasource to an oracle database. Everything you always wanted to know about ODBC connection strings and the iSeries. 6 Object Library To use fncGetChecks, call it from a form or simply type: fncGetChecks into the immediate window of the Visual Basic Editor. A connection string can be pasted into the EDT Data Source connection string text box as highlighted below. Open "DRIVER={Microsoft Access Driver (*. Copy table Products. Connection Strings using Microsoft Access accdb ODBC Driver for connections to Access, Access 97, Access 2000, Access 2002, Access 2003, Access 2007. Given a pre-configured ODBC System DSN, I'd like to write a function that gracefully tests that connection using VBA. Now we have to manually edit the connection to specify its properties. Without adding tables close the Show Table dialog box. But we cant afford to get it at work. Howard s ODBC Connection String FAQ. If that’s the case I only have to change the conConnection procedure from the Access connection, (CurrentProject. It is a custom version of the venerable Visual Basic programming language that has powered Microsoft Excel's macros since the mid-1990s. > relinking odbc tables using vba odbc connection string to the DSN or.