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.
