asked on

uncover hidden objects

I have inherited several old MS Access databases (.mdb) and am in the process of converting them to .accdb. In addition, I am organizing the databases and extract 'common data' and moving them to a single database that will be linked to the other databases. This will allow us to keep data current and limit who has access to updating the data.

In the process of creating the new .accdb database -- and copying all of the object in from the .mdb version - I noticed that there was a module and form that were brought over that were not visible in the old .mdb database. I tried re-compiling the module in the new .accdb - and I get an error msg (see attached) indicating 'User-defined type not defined'. When I go back to the old .mdb database, I don't even see this module listed and the form is open in design mode. There is no documentation for the old .mdb database - so I am trying to determine what this 'hidden' module is doing.

Any ideas how to find this module in the old .mdb database? Any ideas on how to determine what it is doing?

Could there be an external executable that calls this module?

Thanks for the help,
je
C---MS-Access-Database-Consolidation-Err

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

j e

ASKER

It seems to work fine even when the code is not compiled. I tried creating a fake module in the old .mdb database to look at the references -- and got the same compile error. So I think I'll just leave it as is for now.

Thanks for pointing me to the references.
je