Queries not showing up

[jerky007]

Ok guys,

I inherited this application(vb6) recently and I am trying to figure out how it is talking to the database. It turns out that it uses an Access 2000 database and uses two files.. *.pmdb and *.pmdw. I am guessing they are just renamed .mdb and .mdw files. I can load the .mdb file straight into access, but there are 0 queries saved into it. They must be in there somehow because the app works fine. So my question is.. has anyone had a similar problem? Does anyone have any ideas?

Here is some more relevant info.

This is how you open the files together in access:
Put the following string in the target field of your icon.

"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "c:\program
files\resman\blank.pmdb" /wrkgrp "c:\program files\resman\blank.pmdw"


This is the function that executes the psuedo stored procs... I know access technically doesn't have them.

'
' Generic Post When a Stored Proc Exists
'
Public Sub ExecuteCommand(sCmd As String, ParamArray params() As Variant)
On Error GoTo ErrorTrap
    Dim cmd As New ADODB.Command
    Set cmd.ActiveConnection = gcnDatabase
 
    cmd.CommandType = adCmdStoredProc
    cmd.CommandText = sCmd
    If UBound(params) > 0 Then
      cmd.Execute , params, adExecuteNoRecords
    Else
      cmd.Execute , , adExecuteNoRecords
    End If
Exit Sub
ErrorTrap:
    gpErrorHelper.NonTerminalErrorHandler Err, Erl, MODULE_NAME
End Sub
 

Thanks for any help guys, I am really stuck here.

[Rabbit]

They're probably just hidden. Tools > Options > View tab > Hidden Objects checkbox.

[jerky007]

They're probably just hidden. Tools > Options > View tab > Hidden Objects checkbox.

Thanks for the idea, but unfortunately it did not work. Any other ideas?

[Rabbit]

I didn't look at the code before hand but it looks to me that there are no stored queries. They're just passed as SQL strings in the code.