Microsoft Office Access Error

[Rita D via AccessMonster.com]

Hello,

I got this database from a friend and when it opens up, a form opens up. When
I click on either the Search tab or the view report tab, I get this error,
"Your Microsoft Office Access database or project contains a missing or
broken reference to the file cr92.mde,
To ensure that your database or project works properly, you must fix this
reference."
The error message box goes away if I close it, and then everything else seems
to work. How can I get rid of that annoying error?

Thanks,

Rita

 

[Guest]

If the Access database file you got from your friend is an mde file, there is
nothing you can do about it. If it is an mdb file, then you would have to
determine where in the processing it references cr92.mde and remove the
reference.
My concern is it appears everything is working, but if it is referencing
another database file, then at some point something will not work because it
uses that file.

 

[Rita D via AccessMonster.com]

If the Access database file you got from your friend is an mde file, there is
nothing you can do about it. If it is an mdb file, then you would have to
determine where in the processing it references cr92.mde and remove the
reference.
My concern is it appears everything is working, but if it is referencing
another database file, then at some point something will not work because it
uses that file.

Thanks Klatuu for your response.

Yes, it is an mdb file.
I deleted that reference about three months ago and it just started asking me
again. I followed this instructions,
"The application you are attempting to use has a reference it cannot resolve
to an object, type library, DLL, or external database.  Either the object,
type library, DLL, or database was deleted or its name has changed. Examine
the Available references list in the References dialog box in the Visual
Basic Editor (Tools menu) to determine if any action is required. If you did
not create this application, contact the programmer or administrator of the
system.
If the reference listed in the Available references list is preceded with
"MISSING:" clear the check box to remove the reference if it is no longer
required. If you still need to use the reference, clear the check box entry
for "MISSING: <referencename>" in the Available references list, and then
create a new reference to the file using the Browse... button. If this is an
installed database application, you may need to reinstall or repair the
application."
Am I doing the right thing to solve this problem? I don't want the database
to get corrupted.

 

[Guest]

Aha! whoever created the application used cr92.mde as a code library. So
what is happening is that some code is calling a sub or function the was in
cr92.

 

[Rita D via AccessMonster.com]

Aha! whoever created the application used cr92.mde as a code library. So
what is happening is that some code is calling a sub or function the was in
cr92.
[quoted text clipped - 25 lines]

Am I doing the right thing to solve this problem? I don't want the database
to get corrupted.

Is there a way to delete it? I just don't want to keep getting that error
message.

Thanks again,

Rita.

 

[Guest]

You would have to experiment to find what code is referencing code or object
in cr92 and delete that code. In any case, your database will then not be
fully functional. Hopefully, your friend can provide you a copy of it.

Aha! whoever created the application used cr92.mde as a code library. So
what is happening is that some code is calling a sub or function the was in
cr92.

If the Access database file you got from your friend is an mde file, there is
nothing you can do about it. If it is an mdb file, then you would have to

[quoted text clipped - 25 lines]

Am I doing the right thing to solve this problem? I don't want the database
to get corrupted.

Is there a way to delete it? I just don't want to keep getting that error
message.

Thanks again,

Rita.

 

[George Nicholson]

Rita:
You said you removed a cr92.mde reference months ago but the error message
you are getting ("Can't resolve reference...") indicates that it has come
back (how else would the error message know the name of the missing ref?).
If that's the case, try removing the MISSING ref again & recompile & save.

If your code compiles without the reference, then you might be ok. Since you
say everything is fine once you get past the error message, I suspect this
is the case for you. However, you might consider doing a Find within your
code modules on "cr92.mde" to see if there is some code that is trying to
add the mystery reference back in and comment it out to prevent the error
message from returning.

If, without the reference, you start getting "Undefined user type" errors
during compile, or "Unknown property/method", "Type mismatch", etc. errors
while running those *might* be indicating that you need the missing
reference (and its file) after all. But, you aren't getting them now, so
removing a MISSING ref probably won't cause them to start.

HTH,
--
George Nicholson

Remove 'Junk' from return address.

Aha! whoever created the application used cr92.mde as a code library. So
what is happening is that some code is calling a sub or function the was
in
cr92.

If the Access database file you got from your friend is an mde file,
there is
nothing you can do about it. If it is an mdb file, then you would have
to

[quoted text clipped - 25 lines]

Am I doing the right thing to solve this problem? I don't want the
database
to get corrupted.

Is there a way to delete it? I just don't want to keep getting that error
message.

Thanks again,

Rita.