Microsoft Access Sample Code

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, sometimes you need to have a programmatic/dynamic way to accomplish this through VBA. This handy function will allow you to create linked tables right 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 file. '* In: * '* strTable - name of linked table to create * '* strPath - path and name of MDB file containing the table * '* strBaseTable - name of table in strPath MDB * '* 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

Having problems getting the code to work for you - then try out the demo to see if the demo works for you.

Download a demo version for free to try out. The demo version is in Access 2007 which will work on either Access 2007, 2010 or 2013. If you need a previous version of Access to tryout, please Contact Us. Please note that the demo version of the software is fully functional but doesn't allow you to see the code implementation - the full version allows you to design the code implementation and tweak it for your needs.

Access 2007/2010/2013 Download

The full version of the database is a standard Access Database file. You 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 that you wish. If you lack the time to integrate this database into your system, please Contact Us and we'll be glad to help. If you like the basics of what you see, but need enhancements to make the system functional for you, please Contact Us and we'll develop a quote for you to implement the additional features and enhancements that you need.

The cost of the Access Linked Table Database is as follows:

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

Once your purchase is complete - you will receive an email with a link to download the full version of the database.

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 

Click Here to learn more about the WSI quoting process.