Updating a split ms access database photo dating profile
The code that populates our List Box with all linked table connection strings is simply a loop that looks at all of the tables in our database, decides which ones to show in the List Box and then displays their names and connection string using the properties above: Private Sub Refresh List() Dim tdf As DAO.
In this article we will use VBA to retrieve and display the connection strings for the linked tables in a front-end database.
Fortunately, Microsoft Access 2010 provides the ability to split a database into front-end and back-end components.
You can safely share data with other users while keeping your interface private, providing each user a local copy.
Your back-end database is now stored using the name you provided.
The original file still contains the front-end portion of the database.