Access conversion from 97 to 2003

[work]

I am trying to convert a database from Access 97 to Access 2003 but for some reason it's not compiling the code..I looked for some solutions at Microsoft but that didn't help..here is where it gives me the compiling error...it says "Ambigous name detected and it does not compile.

here is the code where it gets stuck

Private Sub Print_Record_Click()
On Error GoTo Err_Print_Record_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection

Exit_Print_Record_Click:
Exit Sub

Err_Print_Record_Click:
MsgBox Err.Description
Resume Exit_Print_Record_Click

End Sub

 

[Joe4]

Take a look at the your VB references (in the VB editor, go to Tools | References) and make sure you have the same number of references selected in your converted 2003 database as you do for your 97 database. If not select the appropriate reference. The names should be fairly similar, just different version numbers.

 

[SydneyGeek]

Also, try compiling it in Access 97 BEFORE doing the conversion. (that is, if you still have 97 available). I've found that, without doing this, some features (like creating MDE files) will not work in Access 2002, and presumably 2003.
When the Ambiguous name detected" pops up, is it the name of the Sub, or one of the code lines? You may find that you have 2 Subs with the same name in the module.

Denis