Working with Windows 7 and VB 6.0. When I "flag" Module 2 (listed below) and watch it execute, everything is OK with the Connection String as: "C:\Rwo1\General Ledger.mdb". However, when the calling projram executes, it attempts to access a
totally different DB ("C:\Actg\DONAR\General Ledger.mdb").
Public gConn As ADODB.Connection
Public Function OpenConnection()
Set gConn = New ADODB.Connection
Public Function DatabasePath() As String
DatabasePath = App.Path & "\General Ledger.mdb"
Public Function ConnectionString() As String
ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" _
& DatabasePath & ";Persist Security Info=False"
Why doesn't the program which follows (using an ADO DataGrid) access the DB called
in the Module? I hope someone can help.