Can't find or edit macros

[RaunLGoode]

I have inherited several Access DBs that were on the personal hard drive of a developer who has left this company. We need to move the data bases to a secure server environment.
There are several Macros associated with each of these DBs. I need to review the Macros to resolve any mapping issues related to relocating the DBs. I can see one Macro in the Navigation window, but can only view the Macro by converting it to VBA. When I convert the Macro to VBA, I can see that this macro basically launches two other Macros I cannot find anywhere.

My last experience developing Access was with 2003 or earlier. Obviously a great deal has changed. Could someone please give me some direction on finding and editing all the Macros in a .mbd file?

 

[SpentGeezer]

.mdb = 2003 or prior, so you just click on the macros objects in the database window then select the macro and click design. If you are using 2007 then:

The left side of database window has a 'Navigation Pane'. Click on the >>
at the top to open. Click on the downward arrow to view other object types.

If you can't see the navigation pane go into access options and turn it on.

 

[RaunLGoode]

Thanks for the reply. Let me clarify. My Experience is with Access 2003. The DBs I am migrating are in Access 2010. I have the Navigation pane open. but I can only see one Macro (ReloadData) in the Nav pane and I can't open / edit it unless I convert it to VBA. When I convert "ReloadData" to VBA I get a short routine that launched two other macros: "DeleteTables" & "Import Data". The "DeleteTables" & "Import Data" macros do nor show up on the navigation pane and I cannot find them in the VBA editor.
See entire VBA translation below:

Function ReloadData()
On Error GoTo ReloadData_Err

' Delete data in all tables
DoCmd.RunMacro "DeleteTables", , ""
' Import and load data into all tables
DoCmd.RunMacro "ImportData", , ""


ReloadData_Exit:
Exit Function

ReloadData_Err:
MsgBox Error$
Resume ReloadData_Exit

End Function

Any help is appreciated

 

[jkl0]

Make sure objects are not hidden.

Right-click the menu at the top of the Navigation Pane, and click Navigation Options.
Under Display options, select the Show Hidden Objects check box.

 

[RaunLGoode]

jklo and SpentGeezer,
Thanks!
The 2 missing files were hidden and I think I understand how to edit the Access Macros.
Again many thanks