Database not opening when using VBA
Posted on 2012-03-14
I have an ACCESS 2003 database that I am using to open other databases. This "menu" database only has one form and on that button that open other databases. However, I am trying to set up the first database and while the "child" database has an lb file saying I am in it, I cannot see the database.
Private Sub lblCAR_Click()
Dim appAccess As Access.Application
Dim strDB As String
Const strConPathToSamples = "\\Sf1\User1\" & _
strDB = strConPathToSamples & "LMR_FE_UserTesting.mdb"
' Create new instance of Microsoft Access.
Set appAccess = CreateObject("Access.Application")
' Open database in Microsoft Access window.