Link Table Template

Function for Creating a Linked - Attached Table

In Access, you may find the need to link to tables. While Access has many great built-in features to allow this linking, sometimes you need to have a programmatic/dynamic way to accomplish this task through VBA. This function will allow you to create linked tables from the code in your Microsoft Access Database.

Function createAttached(strTable As String, strPath As String, strBaseTable As String) As Boolean '************************************************************************************ '* Create an attached table in the current database from a table in a different MDB, ACCDB file. '* In: * '* strTable - name of linked table to create * '* strPath - path and name of MDB, ACCDB file containing the table * '* strBaseTable - name of table in strPath MDB, ACCDB * '* Out: * '* Return value: True/False, indicating success * '* Modifies: * '* Nothing, but adds a new table. * '************************************************************************************ On Error GoTo CreateAttachedError Dim tdf As TableDef Dim strConnect As String Dim fRetval As Boolean Dim myDB As Database DoCmd.SetWarnings False Set myDB = CurrentDb Set tdf = myDB.CreateTableDef(strTable) With tdf .Connect = ";DATABASE=" & strPath .SourceTableName = strBaseTable End With myDB.TableDefs.Append tdf fRetval = True DoCmd.SetWarnings True CreateAttachedExit: createAttached = fRetval Exit Function CreateAttachedError: If Err = 3110 Then Resume CreateAttachedExit Else If Err = 3011 Then Resume Next End If End If End Function

Once you purchase the database template, you will receive the full version of the database in a standard Access Database file. The purchased database will have full access to the database window, all design objects, the visual basic project code, and you will be able to modify or add to the design in any way you wish (this does not apply to the run-time/compiled versions). If you lack the time to integrate this database into your system, please Contact Us and we will be glad to help with your integration process. If you like the basics of what you see in the database, but need enhancements to make the system functional for your business, please Contact Us and we will develop a quote for you to implement the additional features and enhancements that you require.

$19.99 - this allows you to use this database template however you wish within your organization.