Conversion help

[Trisha Schneider]

I'm trying to convert a database from A97 to A2000. I made a copy of
my database and then attempted the conversion. During the conversion,
I get this message: "There were compilation errors during the
conversion or enabling of this database. The database has not been
saved in a compiled state..."

So I tried compiling the A97 database before converting, but I get
this message "Compile error: Sub or Function not defined". It is
getting stuck at this point...this part
"Me!STATUS = SCID_Update_Status(Screen.ActiveForm, Me!ID, Me!CDATE)"
is highlighted.

Private Sub cmdUpdate_Status_Click()
If IsNull(Me!ID) Or IsNull(Me!CDATE) Then
MsgBox "ID and Date of Interview are required before this
object can be executed."
Else
Me!STATUS.Locked = False
Me!STATUS = SCID_Update_Status(Screen.ActiveForm, Me!ID,
Me!CDATE)
Me!STATUS.Locked = True
End If
End Sub
Also, when I attempted to import existing A2000 modules into the
"non-compiled" converted database, I get the message "Name conflicts
with existing module, porject, or object library". I have DAO 3.6 and
ADO 2.5 libraries currently checked.

Any ideas?
Thanks

[TC]

The error on:

Me!STATUS = SCID_Update_Status(Screen.ActiveForm, Me!ID, Me!CDATE)

would suggest that there is no function called SCID_Update_Status in your
database.

Open any code module, type ^f (ctrl-and-f) to open the Find box, type
"SCID_Update_Status" (without the quote marks) into that box, then tick the
checkbox that says "whole database" (or somesuch) to search >all< code in
the database. If that funcion is not found, there is your error! The code
never compiled to begin with, or thre function has disappeared somehow. If
that function >is< found, see if the module containing it compiles ok.

HTH,
TC

"Trisha Schneider" <tr******@yahoo.com> wrote in message
news:25**************************@posting.google.c om...

I'm trying to convert a database from A97 to A2000. I made a copy of
my database and then attempted the conversion. During the conversion,
I get this message: "There were compilation errors during the
conversion or enabling of this database. The database has not been
saved in a compiled state..."

So I tried compiling the A97 database before converting, but I get
this message "Compile error: Sub or Function not defined". It is
getting stuck at this point...this part
"Me!STATUS = SCID_Update_Status(Screen.ActiveForm, Me!ID, Me!CDATE)"
is highlighted.

Private Sub cmdUpdate_Status_Click()
If IsNull(Me!ID) Or IsNull(Me!CDATE) Then
MsgBox "ID and Date of Interview are required before this
object can be executed."
Else
Me!STATUS.Locked = False
Me!STATUS = SCID_Update_Status(Screen.ActiveForm, Me!ID,
Me!CDATE)
Me!STATUS.Locked = True
End If
End Sub
Also, when I attempted to import existing A2000 modules into the
"non-compiled" converted database, I get the message "Name conflicts
with existing module, porject, or object library". I have DAO 3.6 and
ADO 2.5 libraries currently checked.

Any ideas?
Thanks